topic Re: how to refresh a qvd file weekly automatically? in QlikView

how to refresh a qvd file weekly automatically?

trishita — Wed, 25 Nov 2020 16:16:04 GMT

I want to refresh a qvd every week so that i dont have to refresh it manually every week.What could be the solution

YoussefBelloum — Tue, 16 Oct 2018 08:01:20 GMT

Hi,

do you use Qlikview server ? with publisher maybe ?

Jesh19 — Tue, 16 Oct 2018 08:10:11 GMT

If it is on Server, then you can set the same in QMC.

If you want to achieve the same on Desktop, you can run a macro.

Check the below link. It might help.

Regards,

Jesh

Miguel_Angel_Baeyens — Tue, 16 Oct 2018 09:24:40 GMT

Using QlikView Server definitely, and Publisher if you have it.

trishita — Wed, 17 Oct 2018 11:51:17 GMT

no i dont have access to it

m_woolf — Wed, 17 Oct 2018 12:18:57 GMT

Use Windows Task Scheduler to open, reload, and close your QVD Generator.

trishita — Thu, 18 Oct 2018 07:54:48 GMT

can someone guide me about the steps how to do it with macros? Like

1.writing a macro

2.writing a batch file

3.and then what??

trishita — Thu, 18 Oct 2018 08:05:37 GMT

is there any example or should i attach my qvw?

rajivmeher — Thu, 18 Oct 2018 09:47:15 GMT

Hi Trishita

You can use the following steps:

1. Create a batch file to reload your QVW from certain location.

2. Use Windows Task Scheduler to run it on specific time (daily or weekly).

Please refer to the attached batch file for reference.

Please note that if you have a Publisher on your server, you can schedule it on your server.

Regards

Rajiv.