topic Re: Delay Trigger in QlikView

Delay Trigger

Tue, 15 Sep 2015 11:56:51 GMT

I have a document with 6 sheets (5 actually but implemented a dedicated 6th reload sheet which triggers a reload).

i have 3 variables controlling the auto switch between sheets (each sheet has a conditional show sheet > vShow = 1 or vShow = 2 etc to enable or hide)

vSheets = 6;

vDelay = 60;

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

i got the above example off the net and it works brilliant to switch automatically at a set delay, but i need to change it up a bit.

Delay for Sheet 1 needs to be 20 seconds and Sheet 2, 3, 4, 5, 6 needs to be 60 seconds.

Ive play'd with triggers and all sorts but i think im overcomplicating it, any help?

Re: Delay Trigger

avinashelite — Tue, 15 Sep 2015 12:01:19 GMT

try like this:

add one more variable for the sheet one delay and use the if condition to act on the hide and show

vSheets = 6;

vDelay = 60;

vDelay1=20;

vShow =if(vSheets=1,ceil((frac(now())*86400/(vSheets*vDelay1)-floor(frac(now())*86400/(vSheets*vDelay1)))*(vSheets)),

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

);

Re: Delay Trigger

Tue, 15 Sep 2015 12:09:16 GMT

Unfortunately that doesnt work as vSheets is never equal to 1.

vSheets is a "max" number of sheets, vShow is used to cycle from 1 - 6 (vSheets)

Re: Delay Trigger

marcus_sommer — Tue, 15 Sep 2015 12:25:00 GMT

You could use the id from the current sheet to have indiviual delays for each sheet:

vDelay = pick(match(getactivesheetid(), 'Document\SH01', ...), 20, 60, ...)

- Marcus