Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
singhnao
Contributor
Contributor

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

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

4 Replies
DavidM
Partner - Creator II
Partner - Creator II

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
Contributor
Contributor
Author

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
Partner - Creator II
Partner - Creator II

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
Contributor
Contributor
Author

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.