Rolling last 3 moths

MartinMCS — Thu, 29 Dec 2022 11:59:58 GMT

Hi all

i have a field "Num (Entry) as Entry" with dates of from 44562(01/01/2022) to 44924(29/12/2022). But here i need a new column of "[Rolling Last 3 Months]", in this column result will be show from 44924 (29/12/2022) to 44833 (29/09/2022). for this i have tried this way......

Tmp:
Load *,
If (num(floor (Entry))=Num (AddMonths (today (),-3)),
1,
0) as [Rolling Last 3 Months]

Resident Table;

Drop Table Table;

But here while i select '1' from Rolling last 3 months field, the rusult shown only 44833(29/09/2022)

The expected result is from 44924(29/12/2022) to 44833(29/09/2022)

Can you guys suggest me where I was wrong here.

Thanks in advance.

Re: Rolling last 3 moths

Or — Thu, 29 Dec 2022 12:03:04 GMT

Shouldn't that be:

If (num(floor (Entry))>=Num (AddMonths (today (),-3)),

topic Rolling last 3 moths in QlikView

Rolling last 3 moths

Re: Rolling last 3 moths