Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.