Multiple Values in Input Parameters in Graphical Calculation View

[adityamalaiya]

I need to filter the values in graphical calculation view. I am having input parameter with Multi Values checked in. It is working fine when I am passing single value and multiple values.

But how can I use this parameter to get all the values without any value?

[BenedictV]

hi Aditya,

There's a round about approach to this. The IN predicate expects least one value, so if you dont provide an input, it would result in an error.

Set a default value as '*'. in the filter do a,

MATCH(<field>, <parameter>) OR IN(<field>, <parameter>)

So when no values are passed the '*' gets all values in the output. When input values are given, the IN predicate filter is used. Note - blank values might still not work.