Dynamic Sheet

[pgalvezt]

Hi all,

I need some help with this. I have 5 Sheets on my Qlikview document and what I want is to change each sheet each 30 seconds, Can you help me with this. I tried with the example here in the qlikview web (Dynamic Sheets = the sheet turn every 10 seconds), but I cant get results. If Anybody can help me with this... Thanks in advance...

[#2]

Jonathan Thank you so much!! You have saved me with that formula!!

[#3]

Hi John,

I'm using this in my script but the tabs will only switch when I interact with the desktop (select menu, etc...) it will not auto rotate on its own. Do you have any suggestions?

Thanks,

Rob

[#4]

This 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)

[simonb2013]

Did you find an answer to this ?

Did it work in the browser, or same issue as when in desktop ?

[#6]

Hi All,

I have a problem.when i am using this method RAM & CPU Utilization going up to 100 percentage.

how to manage this.

Regards,

Lenin

[stabben23]

now function has changed in qv12, use now(1) in the variable.

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

[#8]

Thanks Staffan. I made the change but the tabs are still not switching automatically. They only rotate when I interact with the console.

[#9]

Hi jontydkpi‌ (Jonathan Dienst),

Thank you for the solution to the dynamic sheets rotation. Please, how do you stop/pause a sheet to analyse the sheets/data. I want to be able to pause/stop at a particular sheet anytime during rotation.

Thank you.

[rustyfishbones]

Hi Jonathan,

What way could I do this if I wanted to hold sheet 1 for 2 Minutes and then Sheet 2 and 3 for 30 seconds.

Regards

Alan

[anjali0108]

Thanks.It helped me as well