topic date range not working in QlikView

date range not working

Fri, 17 May 2013 10:47:34 GMT

I've been using the following in set analysis to give me the last 12 months so May 2012 to April 2013, but for some reason records for May 2013 are being included???

Can anyone help?

Thanks

count

({$<DateRaised={">=$(=addmonths(monthstart(today()),-12)) 00:00:00 <=$(=Monthname)today(),-1) 00:00:00"

}

Re: date range not working

m_woolf — Fri, 17 May 2013 10:55:31 GMT

You need addmonths for the second date expression as well.

Re: date range not working

Fri, 17 May 2013 12:32:47 GMT

I've done that but unfortuately it hasnt worked!

count

({$<DateRaised={">=$(=addmonths(monthstart(today()),-12)) 00:00:00 <=$(=addmonths(Monthname)today()),-1) 00:00:00"

}