topic Re: QVD library in QlikView

QVD library

Mon, 22 Feb 2016 14:08:37 GMT

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

Re: QVD library

oknotsen — Mon, 22 Feb 2016 14:16:08 GMT

Open the folder with the QVDs .

Just give them read-only permissions to that folder.

Re: QVD library

Mon, 22 Feb 2016 14:41:17 GMT

thanks,

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

Re: QVD library

Colin-Albert — Mon, 22 Feb 2016 14:51:40 GMT

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) ;

Re: QVD library

Mon, 22 Feb 2016 15:00:35 GMT

Thank you Colin,

Re: QVD library

Anonymous — Mon, 22 Feb 2016 15:07:58 GMT

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.

Re: QVD library

Mon, 22 Feb 2016 15:17:00 GMT

Thanks Bill,

Re: QVD library

ziadm — Mon, 02 Jan 2017 08:11:20 GMT

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