topic Re: how to create a button that apply customized condition in QlikView

how to create a button that apply customized condition

Thu, 06 Dec 2012 15:30:56 GMT

Hello Everyone,

I want to create a button that can apply some conditions based on set analysis.e-g break down of revenue between different departments. Is it possible to achieve using button ? that is when someone press the button the condition becomes true and the formulla is applied.

Regards,

Salman

Re: how to create a button that apply customized condition

Thu, 06 Dec 2012 15:55:38 GMT

My recommendation would be to first create a variable, say vTest. The give your button the action External > Set Variable and make your statement if(vTest=0,1,if(vTest=1,0,0)). This will change the variable vTest from 0 to 1 and back. Then you can create two expressions in your chart and 'Enable Conditional'. One will be vTest=0 and the other will be vTest=1. Does this make sense?

Re: how to create a button that apply customized condition

Gysbert_Wassenaar — Thu, 06 Dec 2012 16:00:04 GMT

or just =not vTest which will toggle it between 0 and -1

Re: how to create a button that apply customized condition

Thu, 06 Dec 2012 16:19:10 GMT

Or that