topic Re: Qlikview Application metadata Information in QlikView

Qlikview Application metadata Information

ashishpalkar — Thu, 18 Jun 2015 16:39:19 GMT

Hi There

I have existing created Qlikview application, is there any way where I can get list of all objects, expressions , QVD's, database connections , etc information?

Thanks in advance,

Re: Qlikview Application metadata Information

ramoncova06 — Thu, 18 Jun 2015 17:08:42 GMT

look into QV prj

QlikView Project Files

It is possible to save a QlikView document into several files that can be used for versioning. Each file defines a property of the document, a sheet, an object, the script etc.

Each time the document is opened and an object or a setting is changed, these changes are saved to the different files, making it easy to follow the changes made in the document. This way it is also possible to see who made a change and to which part of the document.

To create these project files it is necessary to create a folder next to the qvw file with the same name as the QlikView document and add -prj, e.g. the project folder for a document called Finance.qvw should be Finance-prj.

Note!
No data from the document will be saved in the project files.

Files in the Project Folder

The file QlikView.txt contains a list of all the objects part of the QlikView document.

The different sheets and objects in the list are named after their object ID. The project files are:

QlikView.txt - contains a list of all the files included in the project
AllProperties.xml
DocProperties.xml
DocInternals.xml
TopLayout.xml
LoadScript.txt - contains the document load script
Module.txt - contains the document macro code, if any exists
Module.txt - a single file is created for every sheet. In addition the files contain references to all the sheet objects on the sheet.
Separate files are also created for every sheet object:
- LB<id>.xml
- SB<id>.xml
- MB<id>.xml
- TB<id>.xml
- CH<id>.xml
- IB<id>.xml
- CS<id>.xml
- BU<id>.xml
- TX<id>.xml
- LA<id>.xml
- SL<id>.xml
- SO<id>.xml
- BM<id>.xml
- CT<id>.xml
- RP<id>.xml

The files DocProperties.xml, AllProperties.xml, DocInternals.xml and TopLayout.xml all contain property settings for the different parts of the document. DocBinary.dat contains user sensitive data, such as passwords.

in this thread there are a couple of examples on how is done

Creating prj Folder

Re: Qlikview Application metadata Information

ashishpalkar — Fri, 19 Jun 2015 19:27:19 GMT

Thanks for the updates, i was looking for same info.

Re: Qlikview Application metadata Information

MarcoWedel — Fri, 19 Jun 2015 23:30:28 GMT

Hi,

take a look at the Governance Dashboard:

http://www.qlik.com/us/explore/products/qlikview/governance-dashboard‌

http://market.qlik.com/qlikview-governance-dashboard.html‌‌

hope this helps

regards

Marco

Re: Qlikview Application metadata Information

ashishpalkar — Wed, 24 Jun 2015 20:35:38 GMT

Thanks , this is exactly what I am looking for.

Re: Qlikview Application metadata Information

MarcoWedel — Wed, 24 Jun 2015 20:49:48 GMT

very good.

please close your thread

thanks

regards

Marco

Re: Qlikview Application metadata Information

deekshith_juvva — Fri, 14 Feb 2020 07:25:21 GMT

Hi,

The links above are not working now. Are you aware if there's an alternative?

Thanks in advance!