How to find out the list of QVDs, its size and refreshment time.

[singhnao]

Hi All,

I am new to QlikSense. I need a quick help for the following info:

1. How to find the list of all QVDs and its size.

2. How to see the refresh time of a QVD.

Thanks in Advance.

Naorem Thoithoi

[DavidM]

If you are searching just one folder, you can use this:

for each File in filelist ('lib://Data/*.qvd') //-change your path here

QvdList:
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime('$(File)' ) as Modified,
autogenerate 1
;

next File
;

This will generate you a table with name, size and time last modified. From here you can pick the name of the files you want to load, etc

[singhnao]

Hi David,

I am telling what I have done.

1. I create  an app and open the dataloadeditor.

2. I paste the code there and give the correct location.

But it is giving error. I am attaching the screenshot. Please have a look.

[DavidM]

Delete comma before the line autogenerate. The autogenerate should be highlighted in blue

for each File in filelist ('lib://Data/*.qvd') //-change your path here

QvdList:
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime('$(File)' ) as Modified //deleted coma there
autogenerate 1
;

next File
;

[singhnao]

Hi David, 

It is very helpful and working. But, I need one information of QVD refresh duration (including start and end time).

Currently, I am able to get some part of qvd details. Please find the screenshot. 

Thanks,

Naorem.