topic Re: Auto sheet navigation in Qlikview in QlikView

Auto sheet navigation in Qlikview

dineshmdane — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Auto sheet navigation in Qlikview

mdmukramali — Thu, 30 Nov 2017 07:23:06 GMT

Hi,

FYA.

Re: Auto sheet navigation in Qlikview

mdmukramali — Thu, 30 Nov 2017 07:26:04 GMT

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.

Re: Auto sheet navigation in Qlikview

dineshmdane — Thu, 30 Nov 2017 09:24:02 GMT

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

Regards,

Dinesh M