topic Re: OnPostReload + Certain Time in QlikView

OnPostReload + Certain Time

Andrius45 — Mon, 19 Dec 2016 07:35:37 GMT

Hey guys,

So i have a QlikView Document which is supposed to Export&Send few tables just after it gets reloaded. My problem is that it reloads three times per day and I need to send report just on mornings.

How can I achieve it ?

P.S. I had an idea where I would:
1. Create a variable which would change according to time of day(function now()) (on mornings it would be 1, and later during the day 0)

2. OnPostReload would trigger a Macro which would check if my variable is 1 and if it is. then it would run main Macro (Export&Send)

Re: OnPostReload + Certain Time

tamilarasu — Mon, 19 Dec 2016 08:20:23 GMT

Hello Andrius,

Your idea sounds good. I just implement the same in below attached file. Everyday the first reload will trigger the macro. You can test this app by changing the systme date in your desktop.

Re: OnPostReload + Certain Time

Andrius45 — Mon, 19 Dec 2016 08:58:42 GMT

Thanks again Tamil, will definitely try that

Re: OnPostReload + Certain Time

tamilarasu — Mon, 19 Dec 2016 09:43:55 GMT

Not a problem Andrius. kindly let me know If any issues. Have a great week!