Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
yelin_nyu
Creator
Creator

trigger event based on a variable

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

3 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

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)

Regards,
Sergey
yelin_nyu
Creator
Creator
Author

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

SergeyMak
Partner Ambassador
Partner Ambassador

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

PFA

I just added conditions to the triggers

Regards,
Sergey