QVD library

[#1]

Hi all,

I am looking for a solutions to create a list of all existing QVDs and make it available to developers/designers in order to prevent duplicates.

Is there a way to see all existing QVDs without opening qvw files?

Appreciate any input.

Thanks,

Larisa

[oknotsen]

Open the folder with the QVDs .

Just give them read-only permissions to that folder.

[#3]

thanks,

we had a contractor over who started the Qlik. QVD files are not in one folder but in many subfolders. 

L

[Colin-Albert]

You can get a list of files in a folder using the QlikView file functions.

You could create an app that lists all QVDs and their file date to show when they were last updated, no of rows etc.

Look for "File Functions" in the QlikView help for more details.

You can use FIRST 0 to just loads the field names but no data from a QVD

first 0;

TableColumns:

load * from XXX.qvd (qvd) ;

[#5]

Thank you Colin,

L

[Anonymous]

The QlikView Governance Dashboard has an Applications / Lineage tab which gives good visibility of qvd's and qvw's and for each qvw what qvd's it uses as a data source.

It is available free on the QlikMarket and I find it very useful.

It shows loads of other good information like who has accessed what qvw's in AccessPoint and when / how often.

[#7]

Thanks Bill,

L

[ziadm]

Hi Larisa

Provided the search root folders, there is a function already I have developed to loop through these folders looking for *.QVD files and give them out in one Table