Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

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
bramkn
Partner - Specialist
Partner - Specialist

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.

Miguel_Angel_Baeyens

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.