Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

trishita
Contributor III

how to refresh a qvd file weekly automatically?

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

8 Replies
YoussefBelloum
Esteemed Contributor

Re: how to refresh a qvd file weekly automatically?

Hi,

do you use Qlikview server ? with publisher maybe ?

Highlighted
jeshwanth19
Contributor II

Re: how to refresh a qvd file weekly automatically?

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.

Qlikview Desktop auto-refresh

Regards,

Jesh

Re: how to refresh a qvd file weekly automatically?

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

trishita
Contributor III

Re: how to refresh a qvd file weekly automatically?

no i dont have access to it

mwoolf
Honored Contributor II

Re: how to refresh a qvd file weekly automatically?

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

trishita
Contributor III

Re: how to refresh a qvd file weekly automatically?

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
Contributor III

Re: how to refresh a qvd file weekly automatically?

is there any example or should i attach my qvw?

rajivmeher
Contributor

Re: how to refresh a qvd file weekly automatically?

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.