topic Re: Last 3 months data in QlikView

Last 3 months data

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have 3 Years of data ,but i want to load last 3 months data excluding current month.

here i have date field.

For ex this is April month but i need jan, feb, march data if go to next month it has to load feb,march,april like that .

Gysbert_Wassenaar — Tue, 05 Apr 2016 15:46:35 GMT

You can use a WHERE clause to filter the data you load. Something like this:

LOAD

Date,

...some other fields...

FROM

...data source...

WHERE

Date >= num(MonthStart(Today(),-3) and Date < num(MonthStart(Today())

;