Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to load exactly one year data into qvd from DB

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.

 

2 Replies
Highlighted
Digital Support
Digital Support

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

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.
Highlighted
Specialist
Specialist

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

Use function like..

=AddYears(Today(),-1)