topic Re: Filter table based on expression threshold in QlikView

Filter table based on expression threshold

Anonymous — Wed, 24 Jan 2018 19:07:26 GMT

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?

Re: Filter table based on expression threshold

zhadrakas — Thu, 25 Jan 2018 07:20:58 GMT

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.

Re: Filter table based on expression threshold

Anonymous — Thu, 25 Jan 2018 09:09:20 GMT

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

Re: Filter table based on expression threshold

kaushiknsolanki — Thu, 25 Jan 2018 09:12:01 GMT

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

Re: Filter table based on expression threshold

zhadrakas — Thu, 25 Jan 2018 09:21:07 GMT

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, ';')