Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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 (2)
0 Replies