Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Jonathan Thank you so much!! You have saved me with that formula!!
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
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?
=ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets))
vShow=1 (for the first sheet)
vShow=2 (for the second sheet, and so on)
Did you find an answer to this ?
Did it work in the browser, or same issue as when in desktop ?
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
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))
Thanks Staffan. I made the change but the tabs are still not switching automatically. They only rotate when I interact with the console.
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.
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
Thanks.It helped me as well