Auto Tab Switch

[#1]

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