topic Re: How to load exactly one year data into qvd from DB in QlikView

How to load exactly one year data into qvd from DB

vasavidxc — Tue, 21 Apr 2020 11:23:58 GMT

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.

Re: How to load exactly one year data into qvd from DB

Brett_Bleess — Tue, 19 May 2020 18:14:52 GMT

I would recommend starting with the following Help link:

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

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

Re: How to load exactly one year data into qvd from DB

Saravanan_Desingh — Sat, 23 May 2020 14:19:10 GMT

Use function like..

=AddYears(Today(),-1)