Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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
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
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?
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:
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...
indeed... if then endif
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