QVD

[Frédéricdh]

I ask me

In the script editor, you can define a qvd with the function store .... into and then when u request the qvd file, you use the function load.

But every time, when you execute the script, Qlik will build a new qvd file, no?

How to build a qvd only one time, Do I need to build two Qlik file, one to build the qvd and one to read the qvd and work on it?

Frédéric

[PrashantSangle · Accepted solution]

Yes. 

1 for extractor - to fetch data from source & store in qvd.

2 for dashboard - use qvd to design application.

Another approach, (only use, if you have small dataset likely one or 2 tables, few MBs of data)

fetch data from source, instead of storing in qvd directly use in dashboards.

Regards,

Prashant Sangle

[Mark_Little]

Hi,

Normal approach is like the above (Prashant Sangle mentioned)

Other option you could look at subroutines and If statements when calling them.