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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

having issues with automatically moving to next sheet on a reload - stops auto moving

Below is the code I have in my load script.

I then have options on the UI side to actiate auto advance (ser variable to 1) or deactivate (set variable to 0)

Once auto advancing is activated, it works fine, but it stops on a reload - I have added triggers in the document properties On Post Reload to set the variables so the application will continue to automatically advance through the tabs.  It works in development mode when I do a manual reload, and it worked in my test accesspoint when a manual reload was done, but it stops auto paging when the scheduled reload is done in production

script in Load

let vAutoAdvance=0;
[Timing]:
LOAD
recno() as Tab
,
rangesum(Seconds,peek(Seconds)) as Seconds
INLINE [
Seconds
10
10
10
10
10
10
10
10
]
;

[Show]:
LOAD
'=' &
concat('if(vSeconds<' & Seconds & ',' & Tab,'
,') &
repeat(')',max(Tab)) as Show
,'=mod(round((now()-now(2))*86400),' &
max(Seconds) & ')' as Seconds
RESIDENT Timing;
If ($(vAutoAdvance)) = 1 then
LET vShow = peek('Show');
LET vSeconds = peek('Seconds');
ELSE
Let vShow = 0;
ENDIF;

in the button to automatically turn on the auto move to the next sheet and the trigger for the post reload, I have

set variable   - vAutoAdvance setting value to 1

set variable - vShow setting value =Show

0 Replies