topic Re: how to fetch two months data using incremental load in QlikView

how to fetch two months data using incremental load

honeyasha — Wed, 25 Nov 2020 16:16:04 GMT

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

Gopi_E — Sun, 09 Sep 2018 09:36:45 GMT

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 — Sun, 09 Sep 2018 12:56:58 GMT

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