Find the sql or logic for QVD

[ratnakanth]

Hello Everyone,

I have a qvd in the local drive but I could not find the logic or sql for the qvd.

How can I find the sql or script for the QVD?

Please help us.

Thanks,

Ratnakanth

[sergio0592]

Hi,

For create a qvd you have to use the following statement :

Store TableName into File.qvd;

[ratnakanth]

Thanks for your quick response.

I can create and save the qvd but I want to view the script (Instead of the qvd path) of qvd when I add the existing qvd in the other app. 

[Channa]

you can find script for QVD in dataload editor

[Tim_Wensink · Accepted solution]

Hello,

One tip for finding the app which created the qvd, if you open the qvd file with a text editor such as Notepad, you can see which app created the file:

in this case, the qvd was created with a Qlik Sense app, the id between the CreatorDoc tags is the app id that you can use in your url. Maybe this is helpful for locating the script?

Greetings,

Tim Wensink

[jonathandienst · Accepted solution]

And if you look further down in the XML header to the QVD, you will find the lineage entries which may show the SQL query (depending on the creation logic used).