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
