topic Re: Reload Time of qvd in QlikView

Reload Time of qvd

mahendragaur — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Reload Time of qvd

prma7799 — Thu, 22 Jun 2017 07:35:00 GMT

Please check this

Show ReloadTime of a QVD in another QVW

QVD Reload Time? | Qlik Community

Re: Reload Time of qvd

ariel_klien — Thu, 22 Jun 2017 09:12:00 GMT

Hi,

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

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

Ariel

Re: Reload Time of qvd

Peter_Cammaert — Thu, 22 Jun 2017 09:13:51 GMT

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

Re: Reload Time of qvd

Frank_Hartmann — Thu, 22 Jun 2017 09:17:14 GMT

this might be helpful:

Re: Reload Time of qvd

vardhancse — Thu, 22 Jun 2017 09:21:21 GMT

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

Re: Reload Time of qvd

mohammadkhatimi — Thu, 22 Jun 2017 09:30:31 GMT

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