Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

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
Partner
Partner

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

Contributor III
Contributor III

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.