Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rotating sheet variable doesnt activate trigger

Hello,

I have a qlikview app that rotates between each sheet.  The variables for rotating between sheets is below.  Whenever i turn this on, the triggers I have on each sheet that selects what data to present never works.  How to i go about fixing this

vShow =

ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets))

vDelay =15

vSheet = 10


1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I'm guessing that you are making sheet specific selections using the OnSheetActivate trigger. And that you are using the vShow variable to control the visibility of a sheet. Transitioning a sheet between Show/NoShow will not fire an OnSheetActivate trigger.

I'm not sure what the workaround may be, but perhaps others have an idea. I was thinking perhaps you could use an "Activate Sheet" action from a variable trigger, but that resolve the issue because triggers can't fire triggers.

Good luck. Hopefully some better ideas from the group here.

-Rob