Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Load only one time

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

2 Replies
crusader_
Not applicable

Re: Load only one time

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

Not applicable

Re: Load only one time

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