Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Reload frequency of some specific tables in a QVD Generator


Hi All,

Suppose my QVD generator has 10 tabs which has scripts for 10 tables, reloaded at a certain point of time (Ex: 12AM) and those are stored as 10 QVDs. Clear!!!

Now my requirement is to run a specific set of tables (let table 3 and table 7) at certain fixed period of time in a day(Ex:12AM, 3AM, 6AM). At this instance no other tables will be reloaded again to save time.

Please let me know how to achive this. Please post some sample scripts/QVW for this.

Regards!!!

1 Solution

Accepted Solutions
dmohanty
Partner - Specialist
Partner - Specialist
Author


I managed to achieve this using Variables like this. It is working fine. Please use.

LET vReloadStart = now();

LET vSpecialReload = 0;  //Variable for specific reload
LET vReload = 1; //Variable for common full reload

IF hour(vReloadStart) = 5   or hour(vReloadStart) = 9 then

LET vSpecialReload = 1;
LET vReload = 0;              

ENDIF

View solution in original post

6 Replies
narender123
Specialist
Specialist

Hi,

You can create 2 Qlikview Generator .1 is scheduled(heaving table1 and table3) as you  want  3 time in day and other is daily basis.

and stored Qvd's from both generator in single location.

Thanks.

Narender

dmohanty
Partner - Specialist
Partner - Specialist
Author

That would be simple

Can't it be done from any other ways: In one QVD generator itself? using Partial Load or with some other scripts?

dmohanty
Partner - Specialist
Partner - Specialist
Author


I guess this can be done through Partial Reload also. I can add the ADD/REPLACE command in the specific table script.

But please let me know how to do a Partial Reload of this QVW in QMC?

Requirements should be in mind:

  1. First time the QVW will undergo a full reload at a scheduled time.
  2. Next time onwards the QVW will undergo Partial Reload at certain hours.
israrkhan
Specialist II
Specialist II

hi,

i am not sure, and not tested, but one idea coming in mind.

could you not write a if statement in script,in which you could check if time = 6 pm or 3 pm and so,

to load else dont...

Anonymous
Not applicable

indeed... if then endif

dmohanty
Partner - Specialist
Partner - Specialist
Author


I managed to achieve this using Variables like this. It is working fine. Please use.

LET vReloadStart = now();

LET vSpecialReload = 0;  //Variable for specific reload
LET vReload = 1; //Variable for common full reload

IF hour(vReloadStart) = 5   or hour(vReloadStart) = 9 then

LET vSpecialReload = 1;
LET vReload = 0;              

ENDIF