Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
;
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.