Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If i want to fetch only two months data by using incremental load ,please some one help me .
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
For a general approach of how incremental reload is implemented in Qlik, check this article https://www.quickintelligence.co.uk/qlikview-incremental-load/