Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Rotating sheets

Hi,

May be like this.

Regards

ASHFAQ

MVP
MVP

Re: Rotating sheets

Re: Rotating sheets

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

Re: Rotating sheets

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

Community Browser