Discussion Board for collaboration on QlikView Scripting.
I have this situation.
I need load a qlikview document depend of a value of one field in database that tell me if load in Oracle finish or not.
So i ask if it is in "1" then load. but i management console i do.
ON SCHEDULE -- HOURLY
RUN EVERY 0 HOURS 10 MINUTES.
RUN ONLY BETWEEN 6:00 AM TO 10:00AM
The problem is after this task (data.task) come (layout task)
if oracle finish at 8:00 it will reload 8:10 8:20 8:30 etc.
I only need one load for day.
Simply add new variable with last reload date information and check it inside your script.
IF $(vLastReload)<date(today()) THEN
..... your script....
LET vLastReload = date(ReloadTime());
Of course document will be called for reloading but nothing will be done on second and afterward calls.
But of course better to use External triggered tasks for these purposes, e.g. Reload after finishing your ETL process.
ok, but how can i do it only one time?
if i do more than one, i next reload same day 10 minutes later will save the doc witouth data.
Think taht data.qvw finish and then has another task layout.qvw