topic Re: Controlling two conditions in a same table chart by button in QlikView

Controlling two conditions in a same table chart by button

rsdhavle — Tue, 17 Jun 2014 07:19:51 GMT

I have one straight table chart in which i have applied condition on each expression lets say if the value is greater than 50% then only display the value and corresponding row. Now suppose i have introduced two buttons when i click on one button this condition should get applied on the straight table and when i click on another button the same straight table should show all the values. How can it be done?

Note: I want to do it in a single object and not by using two objects and controlling it on a button

Re: Controlling two conditions in a same table chart by button

Gysbert_Wassenaar — Tue, 17 Jun 2014 07:49:30 GMT

Create a variable vUseCondition and give it the value -1 (=True). Add a Set Variable action to your button to set the value of the variable to =not $(vUseCondition).

Modify your original chart expressions to something like:

=if( $(vUseCondition), if(sum(Value)>0.5, sum(Value)), sum(Value)

Re: Controlling two conditions in a same table chart by button

rsdhavle — Tue, 17 Jun 2014 09:38:49 GMT

Thanks , it worked.