Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the all qvd reloads time?

Hi ,

      I have 20 qvd's in qvd's folder.my requirement is i want to show all the qvd's last reloaded time individuvally.like below image.plz help me on this.

regards,

1 Solution

Accepted Solutions
maxgro
MVP
MVP

for Each file in filelist('QVD\*.qvd')

qvd:

LOAD distinct

  '$(file)' as filename,

  QvdCreateTime('$(file)') as qvdcreatetime

AutoGenerate 1;

next;

View solution in original post

4 Replies
MK_QSL
MVP
MVP

What do you mean by Last ReloadTime.

Are you looking forward when the QVD saved last time? if yes, use as below

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

maxgro
MVP
MVP

for Each file in filelist('QVD\*.qvd')

qvd:

LOAD distinct

  '$(file)' as filename,

  QvdCreateTime('$(file)') as qvdcreatetime

AutoGenerate 1;

next;

Not applicable
Author

Thank u Massimo ...it's working fine....

rasoolshaik
Contributor II
Contributor II

Hi Maxgro,

Instead of loading all qvds from folder. If I want to load only specific qvds. lets say out of 20 I need to load only 5 then how to load.