Auto Tab Switch

Tue, 26 Jan 2016 13:26:35 GMT

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

topic Auto Tab Switch in QlikView

Auto Tab Switch