topic Re: Time based Actions in QlikView

Time based Actions

Fri, 11 Jan 2013 14:33:07 GMT

Hi,

I wondered if anyones know whether there is the possibility of changing the content based on the elapsed time.

Against the scenario, that we have a touchscreen where all employees can use the dashboard, I'd like to implement the two following scenarios:

Scenario 1: Every ten minutes all selections made by the user are discarded (or set back to some predefined selections)

Scenario 2: After fifteen minutes without any actions/ selections a textbox (something like "Please Choose a Year") will be set to visible. As soon as there is a selection it will be hidden.

I tried the last thing by using a variable (LET timeCount = if(mod(minute(localTime()),14) = 0,0,1);) - well but it didn't work out

I appreciate any help and ideas - thank you in advance

Re: Time based Actions

Gysbert_Wassenaar — Fri, 11 Jan 2013 19:32:03 GMT

You can try using the now() function in combination with one or more variables. See here for an example. Be careful though. It can have a negative impact on performance. Or maybe you need to implement it in vbscript. See here for an example of that.

Re: Time based Actions

Mon, 14 Jan 2013 15:41:03 GMT

I am now able to set the object to visible or to hide it. Thank you.

Well, I don't have a clue how to use this to discard the selections every 15 minutes or so. I need a trigger for that, don't I? Thanks in advance!