Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to edit a current script used for reloading data every month and changing it to reload every week instead. I'm not too familiar with coding and qlikview, so I need some help as to how to approach it. The only part of the script I see regarding time is as follows:
LET v30Days= date(floor(Today(0) - 30),'MM/DD/YYYY');
LET vMonth15= Date(MakeDate(Year(Today(1)), Num(Month(AddMonths(Today(1), - 1))), 15),'MM/DD/YYYY');
How should I approach changing it to reload every 7 days instead?
Thanks so much in advance.
Hope this not rloading script every month..
Its incremental reference date created as v30Days.
For reference date to check for 1weekd data,u need to do like.
LET v7Days= date(floor(Today(0) - 7),'MM/DD/YYYY');
But this not automatic script run,tht infact u can do in QMC.
Thanks
In QMC you must change current task.
Printscreen from QMC with Publisher:
how exactly are you performing the reload?
Using QMC? then change setting in QMC itself
Using Windows Task Manager? Then change ins Task Manager.
or are you using a VBA program?