topic Re: Load only one time in QlikView

Load only one time

Tue, 19 May 2015 08:54:03 GMT

Hi,

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.

Thanks

crusader_ — Tue, 19 May 2015 11:23:45 GMT

Hi, Federico,

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());

END IF

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.

Regards,

Andrei

Tue, 19 May 2015 14:41:27 GMT

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.

thanks.

Think taht data.qvw finish and then has another task layout.qvw

regards