Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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/