How to get list of qvd's within any qvw file?

[#1]

Hi All,

I am looking for a way to list the names of all the QVD's that are used in a QVW file and output them to an excel sheet.

The reason behind this request is that I want to change the names of certain QVD but I don't know which all QVW files I would have to change. For that I have to open every dashboard and search for that QVD file name. This is very time consuming.

If anyone has built any tool please help me out with it.

Regards,

Janaki

[swuehl · Accepted solution]

You may want to have a look at

The QlikView Governance Dashboard | Qlik

[PrashantSangle]

Hi,

Use below code

LOAD Discriminator as QVDUsed,

    %Key_DocumentSummary_3E3ED09C8BC69525  

FROM [QvWName.qvw] (XmlSimple, Table is [DocumentSummary/LineageInfo]);

Regards

[Peter_Cammaert]

To add explanation to example: every QVW has an embedded XML header that can be read by QlikView and that contains lineage information. The XML header is filled and updated by simply executing the contained load script. Tools like the Governance Dashboard make use of this XML header to discover environment-wide lineage information (if you use multiple data stages for example).

The information is pretty rudimentary but it will serve your purpose.

Best,

Peter

[#5]

Thank you all for the reply. I got what I needed finally.