Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

QvdCreate time

hi Team,

 

i am trying top get the create time for the QVD's. I am using below code and every time QVD create time is giving null().

 

Can anyone please tell me what is  wrong with the code?

 

 

set vQVD = '..\QVD\';

QVD1:
Load * Inline [
ID, Sales,State
1, 200, NYC
2, 100, NJ
3, 260, MA];

Store QVD1 into $(vQVD)QVD1.(qvd);

Let vQVDCreateDate1 = QvdCreateTime('$(vQVD)QVD1.(qvd)');  // its giving null not sure the problem.

 

Thanks

Labels (3)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this working for me.

set vQVD='D:\Suresh';


QVD1:
Load * Inline [
ID, Sales,State
1, 200, NYC
2, 100, NJ
3, 260, MA];

Store QVD1 into [$(vQVD)QVD1.(qvd)];

Let vQVDCreateDate1 = QvdCreateTime('$(vQVD)QVD1.(qvd)');

View solution in original post

2 Replies
Chanty4u
MVP
MVP

Try this working for me.

set vQVD='D:\Suresh';


QVD1:
Load * Inline [
ID, Sales,State
1, 200, NYC
2, 100, NJ
3, 260, MA];

Store QVD1 into [$(vQVD)QVD1.(qvd)];

Let vQVDCreateDate1 = QvdCreateTime('$(vQVD)QVD1.(qvd)');

Brett_Bleess
Former Employee
Former Employee

It appears the relative path you were setting may have been the issue, the Help does not show that in an example, so I am not sure if relative paths work here, just wanted to post this for future folks.

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FileFu...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.