topic Qlikview Load Variable in QlikView

Qlikview Load Variable

warrenpress — Tue, 23 Sep 2014 08:20:52 GMT

Hi,

I have a QVW that loads at quarter past every hour but I want to add into the script a statement to the start of the that will mean it doesn't load at 11:15am, 12:15pm or 13:15.

How would i accomplish this?

Thanks in advance

Re: Qlikview Load Variable

jyothish8807 — Tue, 23 Sep 2014 08:23:49 GMT

Hi Warren,

Can you share the script you are using to load the QVW at every quater past ? It will be helpuf to find a solution.

Regards

Re: Qlikview Load Variable

geert_gelade — Tue, 23 Sep 2014 08:39:04 GMT

Maybe you can use something like this in the beginnnig of the script:

let vReloadTime=now();

if (hour(vReloadTime) >=11 and hour(vReloadTime) <=13 ) then

//do nothing

else

//put your load statement here

end if;

Re: Qlikview Load Variable

ashfaq_haseeb — Tue, 23 Sep 2014 08:46:02 GMT

Hi,

If you have publisher the you can use hourly and then you can set trigger to run between XX:XX and XX:XX.

Regards

ASHFAQ

Re: Qlikview Load Variable

warrenpress — Tue, 23 Sep 2014 14:49:27 GMT

Hi,

I am currently using QlikView Management Console to schedule the reloads.

Regards

Re: Qlikview Load Variable

warrenpress — Tue, 23 Sep 2014 14:50:32 GMT

Ashfaq Mohammed wrote:

Hi,

If you have publisher the you can use hourly and then you can set trigger to run between XX:XX and XX:XX.

Regards

ASHFAQ

HI,

Im trying to avoid having to purchase publisher.