topic Rolling 2 months Data in QlikView

Rolling 2 months Data

Thu, 07 May 2009 03:01:08 GMT

Hi,

I need to calculate amount for last two months.

I have month and amount field. I need to calculate the amount for last two months, like I need to calculate amount for march and april. How to do this in the expression of a chart?

Rolling 2 months Data

johnw — Thu, 07 May 2009 03:12:03 GMT

It may be as simple as going to the Expressions tab, selecting Accumulate for that expression, and entering 2 for Steps Back.

Rolling 2 months Data

Anonymous — Thu, 07 May 2009 03:17:51 GMT

It may look like this, assuming that in May you want to see March and April:
sum(if(Date>=monthstart(addmonths(today(), -2)) and Date <=monthend(addmonths(today(), -1)), Amount))

Rolling 2 months Data

Anonymous — Thu, 07 May 2009 03:19:40 GMT

John's solution looks simpler - that means better, if it works for you.

Re: Rolling 2 months Data

qlikview979 — Sat, 04 Jun 2016 09:24:23 GMT

Try like this

=sum({<YEAR={">=$(=(AddMonths(Max(YEAR),-2)))<=$(=(AddMonths(Max(YEAR),-1)))"}>}SAL

Regards,

Mahesh.