Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rotating sheets

Hi

i have about 10 - 15 sheets in my project.. i want change each sheet every 30sec.. and after the last sheet again to start the cycle..  can some one help me out in this??

help will be greatly appreciated

thank you in advanced

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

May be like this.

Regards

ASHFAQ

maxgro
MVP
MVP

ashfaq_haseeb
Champion III
Champion III

Hi,

I remember you have personnel edition

In this case create 5 sheets in a new qlikview document and go to sheet properties and select conditional and write below code for specific sheets.

Sheet1:

=======

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 1

Sheet2:

=======

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) >= 1 and

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 2

Sheet3:

=======

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) >= 2 and

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 3

Sheet4:

=======

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) >= 3 and

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 4

Sheet5:

=======

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) >= 4 and

(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 5

Image attached.

Regards

ASHFAQ

Not applicable
Author

Hi

I have 3 sheets in my qlik view's project

and i want went between them automatically

but i do'nt know do it

Please help me