Filter table based on expression threshold

[Anonymous]

What I want to do: I have a pivot table for which I want to display only lines where an expression is below a "certain value".

I achieved this easily : the expression is something like  if(expression<= $(vThreshold), expression, 0) and ticking "Suppress Zero Values".

But now, how can i make my threshold dynamic (i.e. a list box with my threshold values)? How can I have vThreshold take the value of the selected  item in my threshold listbox?

[zhadrakas]

i think the best way here is to create an Input box that references to your variable.

Then you can manually enter your desired treshold value.

or you can define a Dropdown list with pre-defined values.

[Anonymous]

Thanks for this answer, but I am not sure how to link this "drop-down" to my variable..

[kaushiknsolanki]

Hi,

One of the way is as zhadrakas‌ said, using variable.

Other is if you have the list box for Threshold value you can try Max(ThresholdValue)

instead of $(vThreshold).

Regards,

Kaushik Solanki

[zhadrakas]

Here is a guide how to do this:

1) Create an Input Box Object

2) Add your variable

3) Go to Constraints tab

then you have a drop down like this:

Note that you only enter 10,20 or 30 as Value for treshold.

If you want to that dynamically just Load your treshold Values via Inline Table

Treshold:
LOAD * INLINE [
TresholdValues
10
20
30
];

Then you can add this expression in the listed values field:

concat(TresholdValues, ';')