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