Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
warrenpress
Contributor III
Contributor III

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

Labels (1)
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 III
Contributor III
Author

Hi,

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

Regards

W

warrenpress
Contributor III
Contributor III
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.