Skip to Content

Multiple Values in Input Parameters in Graphical Calculation View

Jun 07, 2017 at 11:41 AM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jun 08, 2017 at 06:14 PM

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.

10 |10000 characters needed characters left characters exceeded