topic Re: Variable trigger onChange in QlikView

Variable trigger onChange

Wed, 26 Mar 2014 13:25:31 GMT

Hi everyone I am trying to make activate different sheet on different times.

In order to achieve that I have 5 sheets and I set up a variable onChange vShow as below.

I see the value of this variable change, but it is not causing the trigger to activate on a change.

Note that I dont want to hide the sheets(as in conditional show) I just want to activate them somehow.

Trigger on vShow to activate sheet:

if($(vShow)=1,'SH07',IF($(vShow)=2,'SH08',IF($(vShow)=3,'SH09',IF($(vShow)=4,'SH10',if($(vShow)=5,'SH11')))))

vShow=if($(vSeconds)<30,1

,if($(vSeconds)<60,2

,if($(vSeconds)<90,3

,if($(vSeconds)<120,4

,if($(vSeconds)<150,5)))))

vSeconds=mod(round((now()-now(2))*86400),150)

Re: Variable trigger onChange

Wed, 26 Mar 2014 13:32:53 GMT

I think you need to have to use vShow instead of $(vShow) in your trigger.

Re: Variable trigger onChange

Wed, 26 Mar 2014 13:39:48 GMT

I have tried that did not work unfortunately.

Re: Variable trigger onChange

Wed, 26 Mar 2014 13:47:16 GMT

I got it to work for me, stupid question probably but have you put an equals sign in front of the if statement?

I put in the Sheet ID section for the Activate Sheet action and it works fine.

=if(vShow=1,'SH07',IF(vShow=2,'SH08',IF(vShow=3,'SH09',IF(vShow=4,'SH10',if(vShow=5,'SH11')))))

Re: Variable trigger onChange

Wed, 26 Mar 2014 13:52:20 GMT

Yes I have. Can you send over a sample??

Re: Re: Variable trigger onChange

Wed, 26 Mar 2014 14:06:08 GMT

sure here you go

Re: Variable trigger onChange

Wed, 26 Mar 2014 14:18:06 GMT

Add "Document\" to sheet name in variable.

es.

=if(vShow=1,'Document\SH07',IF(vShow=2,'Document\SH08',IF(vShow=3,'Document\SH09',IF(vShow=4,'Document\SH10',if(vShow=5,'Document\SH11')))))