Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Incremental load for Insert and update , and also store historic data for 6 month only

Hi

i have a fact table and i have to apply incremental logic for insert and update rows in fact table

in such a way that it should  also store historic data for 6 months.

Because , if i apply only insert and update incremental logic it will not store the historic data.

I want historic data for only 6 months .

ie if i load the data in junly month then it should store historic data only from jan to june.

Can anyone help me in this.

Thanks in advance

Tags (1)
1 Reply
Highlighted
Master II
Master II

Re: Incremental load for Insert and update , and also store historic data for 6 month only

Hi,

It would be better if you post script code that you have in place... it will be easy to give particular solution based on the script..