topic QVD in Integration, Extension & APIs

QVD

Frédéricdh — Thu, 31 Aug 2023 06:56:18 GMT

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 — Thu, 31 Aug 2023 08:46:56 GMT

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 — Thu, 31 Aug 2023 09:41:02 GMT

Hi,

Normal approach is like the above (Prashant Sangle mentioned)

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