topic Re: Reload skript only between certain hours of a day in QlikView

Reload skript only between certain hours of a day

hbuchetmann — Mon, 19 Dec 2016 21:31:29 GMT

Hello fellow Qlik users,

i am looking to a solution for the following Problem:

We use the Qlikview Server Management console to reload an application every 30 minutes.

This mean the Skript runs the whole day every 30 minutes.

My Goal is now to finda solution to only reload the Skript every 30 minutes between 06:00:00 and 18:00:00.

The reson behind this i dont want to actually Access our database when it is not needed. But during Business hours, the application should always have up to date data.

So far i tried the following solution. At the beginning of the script i have:

IF(time(localtime())>='18:00:00' OR time(localtime())<='06:00:00') THEN

EXIT SCRIPT;

ENDIF;

Rest of Skript...

SO far so good, but tee Problem now is the in the hours after 18:00 or before 06:00 the application is empty, because all the data gets deleted when the Skript doesnt run.

From time to time, some coworkers and myself will still Access the application, and i would be nice if the old data from the last real run of the Skript would still be there.

Is there a way to implement this?

Re: Reload skript only between certain hours of a day

lironbaram — Mon, 19 Dec 2016 21:49:54 GMT

you could separate your load process to two apps

one will load data from the DB and save the tables to QVDs

second will apply your logic and will have the user interface

in the management console you define the first app to load every 30 minutes

and the second to start when the first finish.

now if you apply your rule to the first one it'll be empty but the second will always be with data

because it'll load the last updated QVDS

Re: Reload skript only between certain hours of a day

hbuchetmann — Mon, 19 Dec 2016 22:36:27 GMT

Hello Liron,

and thank you for your tip. Good idea and from what i understand it could work. I will try to implement it tomorrow and see if it works.