Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Loop on binary load

My script is in two parts, a binary load that I only need loaded at the beginning of the day, and the rest of the data that I need reloaded every 20 minutes. 

Is there a way of creating a loop or something that will only reload the binary once a day first thing and the rest of the data every 20 minutes?

The binary load is a .qvw file that I am loading into a Qlik Sense app on the server so I can't load it separately and store the data as a qvd.

Labels (1)
1 Reply
jheasley
Luminary Alumni
Luminary Alumni

i would create a data model app that has loading conditions based on the time of day, then have an application layer that does a binary from that data model on every successful reload.  i use the below to make an extract application reload partially on a daily basis and in full on sundays:

Let vMode = If(Match(Weekday(today()),'Sun'),1,0);
Let vReloadType = $(vMode);
 
IF vReloadType = 1 THEN
CALL getHistory;
ELSE
CALL getUpdated;
END IF