topic Re: Current Vs Previous month amount in QlikView

Current Vs Previous month amount

narender123 — Fri, 03 May 2013 06:20:22 GMT

Hi,

I want to calculate this month and previous month amount.If i select march then it should show mar vs feb amount in straight table and by default when there is no selection it should show only Current month Vs previous month amount .

Thanks in advance.

Re: Current Vs Previous month amount

Anonymous — Fri, 03 May 2013 06:34:50 GMT

Hi,

Please check with below exp.

for the current month: (Sum({<[Data Feed Month]={"$(=date(AddMonths([Data Feed Month],0),'MMM YYYY'))"}>} [Charge Rate]))

PrevMonth: Sum({1<SelDate={"$(=date(AddMonths(SelDate,-1),'MMM YYYY'))"}>} DollarAmount)

Thanks

Arun M

Re: Current Vs Previous month amount

nilesh_gangurde — Fri, 03 May 2013 06:45:02 GMT

Hii narender,

For Current Month :

SUM({<MonthField = {"$(=Max(MonthField))"}>}Amount)

For Prev Month:

SUM({<MonthField = {"$(=Month(floor(AddMonths(Max(MonthField),-1))))"}>}Amount)

-Nilesh

Re: Current Vs Previous month amount

er_mohit — Fri, 03 May 2013 07:43:17 GMT

Try this

sum({<Date = {">=$(=MonthStart(Max(Date), -2))<=$(=MonthEnd(Max(Date), -1))"},Year=,Month=>}Amount)

see the attached file

Re: Current Vs Previous month amount

narender123 — Tue, 07 May 2013 07:23:38 GMT

Hi all,

Its not working.

Could you give me the solution with example(qvw).

Thanks.

Re: Current Vs Previous month amount

narender123 — Wed, 15 May 2013 11:43:44 GMT

Hello Guys,

Anybody give me the idea??

Re: Current Vs Previous month amount

Wed, 15 May 2013 12:14:05 GMT

Hi,

if(InMonthToDate(Date,Today(),0,4),1,0) as CMTD/* date which falls under current month*/,
if(InMonthToDate(Date,addmonths(Today(),-1),0,4),1,0) as LMTD/* date which falls under Last month*/

the above expressions will give you 1 and 0-whichever falls under 1 comes into that month

For the current month sales :

=sum({<CMTD={'1'}>} Amount)/*will give you the current month amount*/

=sum({<LMTD={'1}>} Amount)/* will give you the last month amount*/

Re: Current Vs Previous month amount

narender123 — Wed, 15 May 2013 12:21:43 GMT

current month

=SUM({<Year={$(=Max(Year))},Month = {$(=Maxstring(Month))}>}Value)

previous month

=SUM({<Year={$(=max(Year))},Month = {$(=Month(floor(AddMonths(Today(),-1))))}>}Value)

Its working now.

Thanks to all.

Narender