topic Re: SUM action on a Qlikview Button. in QlikView

SUM action on a Qlikview Button.

hkapadia — Fri, 03 May 2019 19:08:45 GMT

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?

Re: SUM action on a Qlikview Button.

bharathadde — Fri, 03 May 2019 19:46:34 GMT

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

Re: SUM action on a Qlikview Button.

hkapadia — Fri, 03 May 2019 21:26:39 GMT

Thanks. I'll give that a try.