topic Re: How to reload automatically every 7 days in QlikView

How to reload automatically every 7 days

Mon, 30 Jan 2017 05:24:32 GMT

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.

Re: How to reload automatically every 7 days

sdmech81 — Mon, 30 Jan 2017 07:04:46 GMT

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

Re: How to reload automatically every 7 days

asgardd2 — Mon, 30 Jan 2017 07:10:23 GMT

In QMC you must change current task.

Printscreen from QMC with Publisher:

Re: How to reload automatically every 7 days

vinieme12 — Mon, 30 Jan 2017 07:45:12 GMT

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?