Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a button object on my Qlikview app & a pivot table with 6 expressions. When I click the button, I want to filter 3 of the 6 expressions to filter data > a certain threshold value using the OR.
For example, Expression 1 > 3 OR Expression 2 > 5 OR Expression 3 > 10
How do I achieve that using a button click?
Try to create 3 variables for 3 thresholds, lets suppose your Thresholds are 3,5, and 10.
Let Variable1=0;
Let Variable2=0;
Let Variable3=0;
Now on button actions assign Variables values --> Like Variable1=3, Variable2=5 and Variable3=10
Now apply conditions on expressions as Expression 1 > Variable1 OR Expression 2 > Variable2 OR Expression 3 > Variable3
Thanks. I'll give that a try.