topic Re: Dates Falling in last 3 months in QlikView

Dates Falling in last 3 months

stuwannop — Tue, 18 Mar 2014 13:49:35 GMT

Hi Everyone

Hope you can help me with a bit of script.

I currently have a line in my calendar script that that will return a 1 if the date loaded falls in the last calendar month. The line is:

IF(InMonthToDate(Date, today(), -1),1,0)

I am trying now to write the same script line but this time to return a 1 if the date falls in the last THREE calendar month - not including the current month.

I've played around with multiple if but I can't quite crack it - can anyone help?

Thanks

Stu

Re: Dates Falling in last 3 months

daveamz — Tue, 18 Mar 2014 14:01:11 GMT

Hi Stu,

Try

If(Date>=MonthStart(AddMonths(Today(),-3)) AND Date<MonthStart(Today()),1,0) as InLast3Months

Best regards,

David

Re: Dates Falling in last 3 months

stuwannop — Tue, 18 Mar 2014 14:04:13 GMT

That's superb David - thanks for your help and the quick response.

Stu