Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
warrenpress
Contributor
Contributor

Qlikview Load Variable

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

W

1 Solution

Accepted Solutions
geert_gelade
Creator
Creator

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;

View solution in original post

5 Replies
jyothish8807
Master II
Master II

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

KC

Best Regards,
KC
geert_gelade
Creator
Creator

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;

ashfaq_haseeb
Champion III
Champion III

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

warrenpress
Contributor
Contributor
Author

Hi,

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

Regards

W

warrenpress
Contributor
Contributor
Author

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.