topic Re: Rotating sheets in QlikView

Rotating sheets

Sun, 25 May 2014 05:31:28 GMT

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

Re: Rotating sheets

ashfaq_haseeb — Sun, 25 May 2014 06:43:35 GMT

Hi,

May be like this.

Regards

ASHFAQ

Re: Rotating sheets

maxgro — Sun, 25 May 2014 07:33:12 GMT

you can find some help here

Re: Changing screens automatically in qlikview

Re: Rotating sheets

ashfaq_haseeb — Sun, 25 May 2014 10:05:29 GMT

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

Re: Rotating sheets

Fri, 06 Mar 2015 11:14:54 GMT

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