topic Re: Change Trigger on Variable not working in QlikView

Change Trigger on Variable not working

Mon, 31 Oct 2011 18:55:06 GMT

I am currently working an application and trying to make a variable trigger another action when the value of the variable changes. This is the formula:

=if(min(floor(Date))>=floor(addmonths(MaxDate,-24)),1,0)

I see the value of this variable change, but it is notcausing the trigger to activate on a change. Do you know if there is a limitation on the variable triggers based on the formula above?

Thanks

Nilesh

Change Trigger on Variable not working

swuehl — Mon, 31 Oct 2011 21:28:20 GMT

I think this should work.

Could you upload a small example app which shows the issue (Upload is available in advanced editor)?

What kind of trigger / action do you use?

Regards,

Stefan

Change Trigger on Variable not working

Wed, 28 Mar 2012 20:42:06 GMT

Hello

The problem is that the trigger action is activated when de variable content/expresion changes, not when de value changes.

In this case the variable content is always the same:

" =if(min(floor(Date))>=floor(addmonths(MaxDate,-24)),1,0) "

so, the trigger isn't fired.

I don't know why... I also have the same "problem".

It would be nice if the trigger being also fired when the evaluated value changes.

Regards,

Cristian

Re: Change Trigger on Variable not working

Wed, 16 Jan 2013 20:34:32 GMT

Hi,

I have similar problem. I dont know whether you found a solution or maybe its mentioned somewhere in the reference manual... I will try to do some more research.

What I've noticed so far, it works when the value of the variable is displayed somewhere on the document sheet. The bad thing is if you have more sheets and you want it to work it must be on all of them just in case you are on another sheet.

Its not difficult workaround but I am surprised by that.

You can create a text object with =YourVariable, change transparency to 100 for background and font colour...

I wont work if you hide it

Regards,

Lukasz

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 11:41:51 GMT

Have you found any solution on that??

I have exactly the same issue and I have not been able to solve it yet.

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 12:00:52 GMT

Check the attached one.

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 12:10:24 GMT

I don't think this will work in my case. As in my example I have 5 sheets and I have a trigger on change on vShow:

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: Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 12:22:07 GMT

I think , Trigger is not required for this

You can write sheet con dition on all sheets

Ex:

Sheet7

Cond : =if($(vShow)=1,1,0)

Sheet8

Cond : =if($(vShow)=2,1,0)

etc...

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 12:52:20 GMT

The problem is that I don't want to hide all sheets apart from one, I just want to activate them as I have another more complex trigger system that activates certain sheets.If the sheets are hidden they wont be able to get activated I guess.

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 13:07:39 GMT

according to the manual reference page 536

"Note!

Actions that trigger other actions, so called cascading actions, may cause unforseen consequences and are not supported!"

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 13:15:20 GMT

Hi Claudio,

I am not using cascading actions. The other triggers are totally separate from this one but if I hide the sheets I guess the sheet activation wont work. I am I correct??

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 13:34:35 GMT

Hi KavrosDA,

not the activation sheet works with the Hidden sheet or not, What do you realy activate?

Re: Change Trigger on Variable not working

Wed, 26 Mar 2014 13:46:47 GMT

I actually have another variable that activates sheets on change and takes input externally.

But I need another one that rolls sheet by sheet every 30 seconds. These two will work collaboratively.

I have tried with hidden sheets on conditional show but my second trigger does not activate the sheet as expected(or actually to be fair it does activate, but it is hidden so its no use).

Re: Change Trigger on Variable not working

Thu, 27 Mar 2014 09:27:06 GMT

Check the atatched one may help..

Note: Don't delete the text object.