How to rotate dashboard tabs in access point

[mandilicious]

Hi All

I have dashboard with 3 sheets that is rotating tabs after a minutes but when i plug it in my  access  point it doesn't rotate like it is on my PC i have to  click refresh manually to rotate tabs.

I used this condition to rotate my tabs =(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 1  which works fine but on my PC not in  access point.

Thanks

[Anil_Babu_Samineni]

In fact, Now() won't work in Access point / Web view. So, That is the bug where i got the information.

[mandilicious]

Hi Anil

Thanks what can be my solution?

Regards

[qlikapple]

hi philip,

i have 5 sheets  which rotates  every 2 minutes

i have cretaed a  variable

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

in every sheet property

for sheet5, we can keep as   vShow=5

for sheet4 , vShow=4

[qlikapple · Accepted solution]

sorry

cretaed 3 variables

i have 5 sheets so i i habe kep

t vSheets=5

vDelay= for every 2 minutes the tab will rotate to other tab so vDelay=120

and

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

and in the sheet  properties  we can keep as vSheet=1( for first tab),vSheet=2( for Second tab),....vSheet=5( for fifth tab)

[mandilicious]

Hi Sahaja    

Please correct me cause it seems not to work.

Thanks

[mandilicious]

Hi Sahaja

Any luck?

Thanks

[Anonymous]

Hi

PFA qvw.

In Sheet conditional used Variable vShow instead of vSheets.

Thanks

[mandilicious]

Hi Sristi,

Thanks for your help,but i doesn't rotate in my Access  point  like it is on my PC i have to  click refresh manually to rotate tabs.mybe  i am missing something.

Thanks

[Peter_Cammaert]

If you plan to use this dashboard on a (large) display screen, maybe you can use the IE-plugin as a client? Just for this screen?