Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.
Thanks again Tamil, will definitely try that
Not a problem Andrius. kindly let me know If any issues. Have a great week!