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

How To add a qvd in another qvd after every 28 Days

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



0 Replies