Auto sheet navigation in Qlikview

[dineshmdane]

Hi All,

Kindly help me to find out any extension or logic that can be used to navigate Qlikview sheets automatically.

Example:

From sheet 'abc' it should navigate to 'pqr' after a minute.

Regards,

Dinesh M

[mdmukramali]

Hi,

FYA.

[mdmukramali]

Hi,

Follow this Dynamic Sheet

• Create a variable vShow with the following value:

=ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets))

• Create variable vSheets = no of sheets to cycle through (5 in this case)
• Create variable vDelay = time in seconds (30 in your case)
• Finally, set each sheet to conditionally display using the expression

vShow=1 (for the first sheet)
vShow=2 (for the second sheet, and so on)

The vShow variable expression will return the value 1, then after 30 seconds, the value 2 etc, causing the displayed sheet to change every 30 seconds.

[dineshmdane]

Thank you Mohammed. It is working fine. Is it possible to stop navigation at the last sheet?

Regards,

Dinesh M