Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to identify where a qvd is created ....

Hi everybody,

Is anyone knows how to find the qlikview program that created a qvd file ???

Maybe a tool exist ??

Thank you for your help !!

1 Solution

Accepted Solutions
Magnus_Berg
Employee
Employee

Hi Thierry, there is a xml meta-data header inside the QVD that states what qvw file that created the qvd. You can load in the meta-data into QlikView by choosing to load xml data but point to the qvd file. You can also open the qvd with an editor and inspect the xml header as shown below, the qvw file that generated the qvd is in blue.

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

<QvdTableHeader>

  <QvBuildNo>12742</QvBuildNo>

  <CreatorDoc>Z:\3.AcmeSales\1.Application\1.QVD-Generator-example\QVD-Generator-Example.qvw</CreatorDoc>

  <CreateUtcTime>2015-04-28 17:23:21</CreateUtcTime>

  <SourceCreateUtcTime></SourceCreateUtcTime>

  <SourceFileUtcTime></SourceFileUtcTime>

  <SourceFileSize>-1</SourceFileSize>

  <StaleUtcTime></StaleUtcTime>

  <TableName>Customers</TableName>.....

Best regards

Magnus

View solution in original post

5 Replies
MK_QSL
MVP
MVP

you can use below functions in QlikView Script to check whether qvd exists or not

Use them in LOAD statement

QvdCreateTime

or

FileSize

Anonymous
Not applicable
Author

I know these functions, but they aren't useful here. In fact, we have some qvd files that we can't remember in which qvw they have been created..

Magnus_Berg
Employee
Employee

Hi Thierry, there is a xml meta-data header inside the QVD that states what qvw file that created the qvd. You can load in the meta-data into QlikView by choosing to load xml data but point to the qvd file. You can also open the qvd with an editor and inspect the xml header as shown below, the qvw file that generated the qvd is in blue.

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

<QvdTableHeader>

  <QvBuildNo>12742</QvBuildNo>

  <CreatorDoc>Z:\3.AcmeSales\1.Application\1.QVD-Generator-example\QVD-Generator-Example.qvw</CreatorDoc>

  <CreateUtcTime>2015-04-28 17:23:21</CreateUtcTime>

  <SourceCreateUtcTime></SourceCreateUtcTime>

  <SourceFileUtcTime></SourceFileUtcTime>

  <SourceFileSize>-1</SourceFileSize>

  <StaleUtcTime></StaleUtcTime>

  <TableName>Customers</TableName>.....

Best regards

Magnus

Anonymous
Not applicable
Author

That's it !!!

Thanks a lot.

Michael_Tarallo
Employee
Employee

I had to guys.


Regards,

Mike T

Qlik

Regards,
Mike Tarallo
Qlik