YoY and MoM % Growth

[#1]

Hi,

I am trying to calculate YoY Income Growth 2015-2014 and MoM Volume Growth May 2015-May 2014 but am unable to get the calculation right.

This is my month Calc to bring in volume

Sum({$<Year={ $(=max(Year)) }>} [PIP_Profit_or_Loss])+ Sum({$<Year={ $(=max(Year)) }>} [Commission_Amount])

This is my month Calc to bring in volume

sum ({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2014','Mar-2015'}, Date =, Week=>} Volume)

Please be so kind as to assist me.

[#2]

Thanks but its also not working

[#3]

post your exp here

[santhoo_san]

copy your complete expression. let us have a look.

[#5]

Thanks

My expression is : =sum({<MonthNumber= {$(=max(MonthNumber-1))},Month= ,Year=>}Volume)

And my label formula is : =(max()-1) , I changed it to =(max()()-1)) but am getting ‘-‘

The one that works is as follows: =sum({<MonthNumber= {$(=max(MonthNumber))},Month= ,Year=>}Volume)

With label: =(max())

[#6]

Try like below,

=sum({<MonthNumber= {"$(=max(MonthNumber)-1)"},Month= ,Year=>}Volume)

[santhoo_san]

Use below expression:

=sum({<MonthNumber= {$(=max(MonthNumber)-1)},Month= ,Year=>}Volume)

I did not understand what you are trying to display in label

And my label formula is : =(max()-1)

[#8]

I want the label to show Feb-2015 instead of 42155

June shows correctly as Jun-2015

Al the calculations are correct as you showed me.

[santhoo_san]

Use :

=Date(Max({<MonthNumber={$(=max(MonthNumber)-1)},Month= ,Year= >}Date),'MMM-YYYY')

[#10]

Its working!!!!

Thank you ☺ ☺

Much appreciated

[#11]

Hi All.

I am new here and new to Qlik and I need some help.

I am having a problem doing MoM analysis. Below is the set analysis function that I am using. For YoY it is working perfectly, however, for MoM it is not. I cannot figure out why, any help is appreciated.

YoY Function that works as intended:

'Repo Charge-off YoY: '& Money(SUM({$<Year={$(=MAX(Year))}>}RepoGLChgoff)-SUM({$<Year={$(=MAX(Year)-1)}>}RepoGLChgoff),'$ ,###.##')

MoM Function that does not work:

&Chr(13)&'Repo Charge-off MoM: '& Money(SUM({$<Month={$(=MAX(Month))}>}RepoGLChgoff)-SUM({$<Month={$((Month)-1)}>}RepoGLChgoff),'$ ,###.##')