Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I would recommend starting with the following Help link:
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
Use function like..
=AddYears(Today(),-1)