topic Re: Re: trigger event based on a variable in QlikView

trigger event based on a variable

yelin_nyu — Wed, 18 Jun 2014 01:14:10 GMT

I want to trigger a set of events when the variable is equal to 1.

say when an user is on tab 1 and selected 'open sesame ' and only this value in field X, I want to apply a series actions happen

otherwise don't do anything. so I create a variable name vAction=if(X='open sesame' and getactivesheetid()='document\SH1',1,0)

how do I trigger events based on variable vAction. I don't want to trigger it upon change:1) doesn't work in Ajax and all my users are Ajax; 2)if the variable change from 0 to 1, action happen--> good; 1 to 0, action happen-->not good.

How do I get action to happen only when vAction=1?

Thanks

Re: trigger event based on a variable

SergeyMak — Wed, 18 Jun 2014 02:11:49 GMT

In case of OnChange trigger (I read that you don't want to use it but...) you can try to use another variable with action and with this variable just set value with condition for the second variable

IF(vAction=1,1,vSecondVariable)

Re: trigger event based on a variable

yelin_nyu — Wed, 18 Jun 2014 02:44:22 GMT

im trying to understand how to implement this. say vAction=0, vSecondVariable=?

Re: Re: trigger event based on a variable

SergeyMak — Wed, 18 Jun 2014 03:01:35 GMT

So, I played a bit with this staff...

PFA

I just added conditions to the triggers