Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor II

Auto Refresh QVD

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.

2 Replies
Highlighted
Partner
Partner

Re: Auto Refresh QVD

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.

Highlighted

Re: Auto Refresh QVD

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.