Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Automatically switch sheets with interval time

I'm trying to setup auto tab switching. I've successfully done this in the desktop client but need it for a ajax client. Does auto tab switching not work in ajax? If I sit a click the screen to force the count, it will switch but not on its own.

I'm using the following code in my script:

[Timing]:

LOAD

recno() as Tab

,rangesum(Seconds,peek(Seconds)) as Seconds

INLINE [

Seconds

15

15

30

];

[Show]:

LOAD

'=' & concat('if(vSeconds<' & Seconds & ',' & Tab,'

,') & repeat(')',max(Tab)) as Show

,'=mod(round((now()-now(2))*86400),' & max(Seconds) & ')' as Seconds

RESIDENT Timing;

LET vShow = peek('Show');

LET vSeconds = peek('Seconds');

DROP TABLES [Show], [Timing];

I then use a variable vShow = 1, et... on my sheets.

Labels (1)