topic Re: QvdCreate time in QlikView

QvdCreate time

qlikuser222 — Sat, 16 Nov 2024 20:35:10 GMT

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

Re: QvdCreate time

Chanty4u — Tue, 25 Jun 2019 17:29:21 GMT

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)');

Re: QvdCreate time

Brett_Bleess — Tue, 23 Jul 2019 11:46:53 GMT

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/FileFunctions/QvdCreateTime.htm

Regards,
Brett