topic Re: Summing the current & previous month in QlikView

Summing the current & previous month

Tue, 05 May 2015 15:52:14 GMT

Hi,

I'm currently having a problem with a piece of Set Analysis which I found on this website - I'm looking at performing a sum on the current selected month plus the previous selected month. The expression I'm using is this:

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),-1)))<=$(=MonthEnd(AddMonths(Max(Date),-0)))"}>}Sales)

However, it seems to be taking the very minimum month in the whole dataset as the min month (i actually want 'current month -1'), and the selected month as the max (which is what I want).

I'm probably missing something obvious... could someone take a look and give me a hand?

Thanks very much!

Re: Summing the current & previous month

buzzy996 — Tue, 05 May 2015 16:11:31 GMT

try this way,

PREVIOUS MONTH

sum({$<Year = {$(=only(Year) - $(=if(only(Month) = 1, 1, 0)))}, Month = {$(=month(addmonths(MonthYear, -1)))}>} LineSalesAmount)

Re: Summing the current & previous month

maxgro — Tue, 05 May 2015 22:15:06 GMT

it seems correct,I just replace my field in your exp and I get (DD/MM/YYYY)

to see the expression as in image, remove the label

Re: Summing the current & previous month

ramoncova06 — Tue, 05 May 2015 22:24:02 GMT

you don't need the addmonths and the monthend function for you current month

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),-1)))<=$(=Max(Date))"}>}Sales)

Re: Summing the current & previous month

nico_ilog — Tue, 05 May 2015 23:00:31 GMT

Re: Current vs Previous Month expression