Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I m new in qlikview . please help me to solve this problem.
suppose I have 2 qvds 'New Report' & 'Old Report' with 2 fields model code & code . 'old report' is to be appended after every 28 days in new report .
I Tried to use QvdcreateTime() to take first qvd date when created.
.
let vSaveQVD = 'D:\Qlikview Development\000 Training\Apoorva\Practice Front End\Incremental Load\Stage1\QVD\' ; let vQVDCreateDate = QvdCreateTime('$(vSaveQVD)OldReport.qvd'); let vQVDDate= Date('$(vQVDCreateDate)'); LET vCurrentDate = date(Today()-28,'DD/MM/YYYY');
NewReport: LOAD Code, ModelCode FROM [..\..\Stage1\QVD\NewReport.qvd](qvd); if ('$(vCurrentDate)' = date('$(vQVDDate)'+28,'DD/MM/YYYY')) Concatenate Incremental: LOAD Code, ModelCode FROM [..\..\Stage1\QVD\OldReport.qvd](qvd); let vQVDDate = date(('$(vQVDDate)'+28),'DD/MM/YYYY');