Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hbuchetmann
Contributor III
Contributor III

Reload skript only between certain hours of a day

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?

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

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 

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

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 

hbuchetmann
Contributor III
Contributor III
Author

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.