Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
hkapadia
Contributor III
Contributor III

SUM action on a Qlikview Button.

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?

2 Replies
bharathadde
Creator II
Creator II

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

 

hkapadia
Contributor III
Contributor III
Author

Thanks. I'll give that a try.