Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Reload Time of qvd

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.

Tags (1)
6 Replies
Highlighted
Master III
Master III

Re: Reload Time of qvd

Highlighted
Specialist
Specialist

Re: Reload Time of qvd

Hi,

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

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

BR

Ariel

Highlighted

Re: Reload Time of qvd

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

Highlighted
Master II
Master II

Re: Reload Time of qvd

this might be helpful:

Aufnahme_2017_05_17_14_11_13_10.gif

Highlighted
Specialist III
Specialist III

Re: Reload Time of qvd

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

Highlighted
Partner
Partner

Re: Reload Time of qvd

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