Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

Auto sheet navigation in Qlikview

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

3 Replies
mdmukramali
Valued Contributor III

Re: Auto sheet navigation in Qlikview

Hi,

FYA.

mdmukramali
Valued Contributor III

Re: Auto sheet navigation in Qlikview

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.

Partner
Partner

Re: Auto sheet navigation in Qlikview

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

Regards,

Dinesh M