Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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