OnPostReload + Certain Time

[Andrius45]

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)

[tamilarasu · Accepted solution]

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.

[Andrius45]

Thanks again Tamil, will definitely try that

[tamilarasu]

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