topic Load only current month data in QlikView

Load only current month data

vireshkolagimat — Wed, 21 Mar 2018 11:32:56 GMT

Hi All,

I have scenario where I need to load only current month information every time the task runs.

For example, i have data for Jan , Feb and March(running). For Jan and Feb there won't be any changes in the sales but for March the numbers will keep on changing until the month is closed. How to perform the incremental load in this case.

Thanks for the suggestions.

Regards,

Viresh

Re: Load only current month data

thevingo — Wed, 21 Mar 2018 12:33:28 GMT

Hi viresh

If records for current month Updated i.e. a rec shows 100 value yesterday, today can be changed to 80.

Then my suggestion is you should load all the data for latest month only by where condition;

where Month=max(Month) // also variable can be used to store max(month) data

also you can find docs for increment load here Incremental Load in Qlikview - Sources