Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-01-26 08:26 AM

Auto Tab Switch

The variables I use for auto tab switch appears to be broken in Qv desktop version 12. I can get it to work in v11 but not v12. In v12 the only way the sheets/tab will switch is when you interact with qv in some way. Anyone know of a fix?

  • Create a variable vShow with the following value:

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

  • Create variable vSheets = no of sheets to cycle through (5 in this case)
  • Create variable vDelay = time in seconds (30 in your case)
  • Finally, set each sheet to conditionally display using the expression

vShow=1 (for the first sheet)
vShow=2 (for the second sheet, and so on)

anyone else have any luck?

Thanks,

Rob

911 Views
0 Likes
0 Replies