Reload Time of qvd

[mahendragaur]

Hello,

I want to show the reload time of qvd files which I used in my dashboard. Is there any way to do the same.

Note:- I don't want to show the reload time of dashboard like Reload(). I have to show the reload time of qvd.

[prma7799]

Please check this

Show ReloadTime of a QVD in another QVW

QVD Reload Time? | Qlik Community

[ariel_klien]

Hi,

you can try in the script putting the file time to a variable:

let vFileTime=FileTime('File_Name.qvd');

BR

Ariel

[Peter_Cammaert]

Every QVD file contains an XML header with details about creation date, number of fields, number of rows etc. QlikView script provides a set of functions to obtain these characteristics without even reading anything from the QVD data.

To get the creation date & time of a QVD file, you can use the QVDCreateTime(filename) function and store the return value in a variable or in a table (if you want to load the creation date of multiple QVD files).

[Frank_Hartmann]

this might be helpful:

[vardhancse]

  Let vReloadTime = QvdCreateTime( 'your QVD file.qvd');

[mohammadkhatimi]

LOAD

'TableName1' as QvdName,

QvdCreateTime('$(RawQvd)TableName1.QVD') as QvdTime

AutoGenerate 1;

Concatenate

LOAD

'TableName2' as QvdName,

QvdCreateTime('$(RawQvd)TableName2.QVD') as QvdTime

AutoGenerate 1;

Hope this will helps u...!!

Regards,

Mohammad