Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

qvd_files and their origin


Hi,

I find quite often that it is somewhat challenging to backtrack a KPI - if the data in the QlikView_database comes from a qvd_file, then the question is which QlikView_app created that qvd. That is somewhat hit_and_miss.

Therefore I wonder: Would it be possible to pass some parameter to a qvd that another app can read that would contain some information on what app created that qvd?

Thanks a lot!

Best regards,

DataNibbler

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Use Qlikview. Simply use the qvd as a file source, but choose XML as file type.


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gysbert_Wassenaar

Every qvd file contains an xml header. You can load the qvd file as an xml file. One of the tags contains the app name that created the qvd. Another interesting bit is the LineageInfo which tells you where the data came from. In the case that data was retrieved from a database you'll find the sql statement and some information about the odbc/oledb connection.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<QvdTableHeader>

   <QvBuildNo>12347</QvBuildNo>

   <CreatorDoc>D:\QVdata\temp\qvd_gen.qvw</CreatorDoc>

   <CreateUtcTime>2014-06-15 15:51:59</CreateUtcTime>

   <SourceCreateUtcTime></SourceCreateUtcTime>

   <SourceFileUtcTime></SourceFileUtcTime>

   <SourceFileSize>-1</SourceFileSize>

   <StaleUtcTime></StaleUtcTime>


...table and field info intermezzo...

   <Compression></Compression>

   <RecordByteSize>35</RecordByteSize>

   <NoOfRecords>41353</NoOfRecords>

   <Offset>2131272</Offset>

   <Length>1447355</Length>

   <Lineage>

     <LineageInfo>

       <Discriminator>D:\QVdata\temp\comm122024.qvw</Discriminator>

       <Statement>Binary</Statement>

     </LineageInfo>

     <LineageInfo>

       <Discriminator>STORE - [AllINK.qvd] (qvd)</Discriminator>

       <Statement></Statement>

     </LineageInfo>

   </Lineage>

   <Comment></Comment>

</QvdTableHeader>


talk is cheap, supply exceeds demand
datanibbler
Champion
Champion
Author

Hi Gysbert,

that sounds really cool.

How can I do that? By changing the extension to .xml, that doesn't work.

Do I need some xml_viewer? That's an issue as everything that has to be installed has to be approved by IT ...

Gysbert_Wassenaar

Use Qlikview. Simply use the qvd as a file source, but choose XML as file type.


talk is cheap, supply exceeds demand
Not applicable

Thank you Sir for that information, very helpfull

datanibbler
Champion
Champion
Author

Perfect!

Thanks a lot!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

I think the Governance Dashboard is a specialist in reading stuff like that. Have a look at The QlikView Governance Dashboard | Qlik

Arindam_Ghoshal_13
Contributor II
Contributor II

Hi Gysbert_Wassenaar,

Do we have any way to find qvd origin in Qlik Sense without using QlikView.

Any suggestions are always welcome.