Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get the qvd last refresh date

Hi

can you please suggest me

                                   how to get the qvd last refresh date

1 Solution

Accepted Solutions
mohammadkhatimi
Partner - Specialist
Partner - Specialist

Hie..

LOAD

'Tablename' as QvdName,

QvdCreateTime('$(Path)Tablename.QVD') as QvdTime

AutoGenerate 1;

Hoe this will helps u..!!

Regards,

Mohammad

View solution in original post

4 Replies
vardhancse
Specialist III
Specialist III

Hi,


Tro to create one variable some thing like using QVDCreateTime


LET FirstReload = isnull(QvdCreateTime('$(vQVDPath)Sample.QVD'));

sunny_talwar

Add the last reload time as a field name

vReloadTime = Now();

Table:

LOAD yourFieldName,

          $(vReloadTime) as ReloadTime

FROM Source;

STORE Table into blahblah.qvd (qvd);

DROP Table Table;

robert_mika
Master III
Master III

in text box:

='Last update' &chr(13)&ReloadTime( )

mohammadkhatimi
Partner - Specialist
Partner - Specialist

Hie..

LOAD

'Tablename' as QvdName,

QvdCreateTime('$(Path)Tablename.QVD') as QvdTime

AutoGenerate 1;

Hoe this will helps u..!!

Regards,

Mohammad