Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

How to find the generator qvw file of a perticular QVD ?

Any one please let me know how to find the Source genetor qvw file for a perticular qvd file.

Thanks in advance.

11 Replies
Not applicable

How to find the generator qvw file of a perticular QVD ?

Hi,

As for as i know there is no feature in qlikview to find out the Source Generator Qvw.

Developer who has developed the appllication should maintain seperate forlder for the Sources Generator Applications.

IF not you need to open all the QVW application and search (Ctrl + F) for the qvd genartaion code.

- Peterson

Not applicable

How to find the generator qvw file of a perticular QVD ?

Thanks alot Peterson..

Not applicable

How to find the generator qvw file of a perticular QVD ?

This doesn't help your problem right now but is maybe something to consider- when any change gets made to a production report, put a copy of the script into sourcesafe/TSF/SubVersion/some other versioning system. This will allow you to easily search it for the reference to the QVD. This is very useful for all sorts of scenarios - including the one that I hate the most:

DBA: I am changing field X to Y

QV developer: Oh ok I shall go and open every qvw and search the script

DBA: oh ok how long will that take?

QV Developer: Longer than it should 🙂

Whilst I remember it is best to put your connection strings into text files (use the Include function in QV to reference them), as going through each QVW to replace a string due to a server name/server IP change is a pain. One change in a text file is easier. I think when I have time I may make a list of these kinds of things. Granted, in each version of QV these kinds of things are getting easier and easier to manage.

Not applicable

Re: How to find the generator qvw file of a perticular QVD ?

I found that if u store the the qvd as an xml file then open it in explorer it will show you meta data about the QVD.

kiranmanoharrode
Contributor III

Re: How to find the generator qvw file of a perticular QVD ?

Hi Vutukuru,

Double click on Qvd file and open with notepad...

on 3rd or 4th line of that notepad file you will find creatordoc, which is the QVW file which generated respective qvd.

Regads

Kiran

Re: How to find the generator qvw file of a perticular QVD ?

Open the qvd with a text editor or xml reader and in the first few lines, the value after <CreatorDoc> is the qvw that generated it.

aushikmakdoom
Contributor

Re: How to find the generator qvw file of a perticular QVD ?

Hi..so in this case we will loose the benefits of loading from the QVD file...correct?

flipside
Valued Contributor II

Re: How to find the generator qvw file of a perticular QVD ?

You can read the data in Qlikview itself ...

QvdTableHeader:
LOAD
Filename() as QVDName,
QvBuildNo,
CreatorDoc,
CreateUtcTime,
TableName,
NoOfRecords
FROM [data1.qvd] (XmlSimple, Table is [QvdTableHeader]);

... but yes this will be a separate load to the data contained therein.

flipside

aushikmakdoom
Contributor

Re: How to find the generator qvw file of a perticular QVD ?

Hi Kiran...This notepad works...Many Thanks