Re: How to load exactly one year data into qvd fro... - Qlik Community

vasavidxc · ‎2020-04-21

Hi All,

I want to maintain a qvd with one-year data,

I want to perform incremental load from DB and want to maintain only one-year data, how to load one-year data till today and how to delete the data which is lesser than one-year from qvd.

Please help me in implementing this.

Thanks,

Vasavi.

Brett_Bleess · ‎2020-05-19

I would recommend starting with the following Help link:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/QVD_Incremental...

Following Design Blog post may be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/Overview-of-Qlik-Incremental-Loading/ba-p/1466780

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.

Saravanan_Desingh · ‎2020-05-23

Use function like..

=AddYears(Today(),-1)

How to load exactly one year data into qvd from DB