Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
honeyasha
Contributor III
Contributor III

how to fetch two months data using incremental load

If i want to fetch only two months data by using incremental load ,please some one help me .

2 Replies
Gopi_E
Creator II
Creator II

Hi rohini,

maybe you need insert scenario by using incremental load, here I am giving example script for insert scenario maybe this expression helpful for you.

Where Date >>= Date(MonthStart(AddMonths('$(zMaxDate)' ,-2)))


this is using when you get data from the database or any flat files


vunguyenq89
Creator III
Creator III

For a general approach of how incremental reload is implemented in Qlik, check this article https://www.quickintelligence.co.uk/qlikview-incremental-load/