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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QVD Refresh time is not coming

Hi ,

      I tried to retrieve the qvd refresh time by using below command. but I am always getting null value?.

LET vQVDLastRefresh =  QvdCreateTime('D:\tmp\3_QVD\Layer_2\AUM_Journey_DB_Test_March_18_Final_backup_18Mar2013.QVD');

     Any Idea?.

Thanks

Dasu.G

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Well just some guesses:

  • The file does not exist.
  • Although it as a qvd extemsion it is not actually a qvd (ie internal format is not QVD and does not contain XML header).
  • The security context under which the script is running does not have access to the QVD location.

I suspect the second as the most likely.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

File exists and I checked there  is an XML header. I am running it from my local machine.. Still issue exists..

Not applicable
Author

Hi,

use,

LET  vQVDLastRefresh= timestamp(QvdCreateTime('D:\tmp\3_QVD\Layer_2AUM_Journey_DB_Test_March_18_Final_backup_18Mar2013.QVD'));

Regards,

Snehal Nabar

Anonymous
Not applicable
Author

Hi I am trying to use below still vQVDLastRefresh time is coming as null.

LET  vQVDLastRefresh= timestamp(QvdCreateTime($(vQVDLevel2Path)Journey.QVD));

But below path is working fine..

LET  vQVDLastRefresh= timestamp(QvdCreateTime('D:\tmp\3_QVD\Layer_2AUM_Journey_DB_Test_March_18_Final_backup_18Mar2013.QVD'));