topic Auto Refresh QVD in QlikView

Auto Refresh QVD

bvssudhakar — Mon, 07 May 2018 14:14:59 GMT

Hi experts,

I have the below explained scenario:

Source File = Excel

Qvd File : Loading data from Excel to qvd through the load script.

Qvw File: Calling the Qvd File in the Work Canvas to create reports.

Now My question is how will the Qvd File get refreshed each time when i reload the QVW file ??

I tried using the Buffer Load , but seems like its not working.

Kindly share your valuable thoughts on how to resolve this.

Thanks in advance.

Re: Auto Refresh QVD

bramkn — Mon, 07 May 2018 14:24:55 GMT

Chain 2 reload tasks in QMC. So first the load script that turns Excel into QVD and then let the dashboard be reloaded when it finishes.

Or put the code the dashboard script to run before loading the QVD files.

Re: Auto Refresh QVD

Miguel_Angel_Baeyens — Mon, 07 May 2018 14:58:57 GMT

Basically you define how and when the source data is loaded and therefore updated into the QVD files. If your application is big and consists of several QVWs (one with script only for extraction, another with script for transformation and another with script for binary/section access), you can do as Bram suggests, creating a chain of tasks in the QMC.

If it's everything on the same script, every time you run it it will read from the source, update the QVDs and then create the data model to be used on the dashboard.