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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reload automatically every 7 days

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.

3 Replies
sdmech81
Specialist
Specialist

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

asgardd2
Creator III
Creator III

In QMC you must change current task.

Printscreen from QMC with Publisher:

vinieme12
Champion III
Champion III

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?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.