Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thanks , it worked.