Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks but its also not working
post your exp here
copy your complete expression. let us have a look.
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())
Try like below,
=sum({<MonthNumber= {"$(=max(MonthNumber)-1)"},Month= ,Year=>}Volume)
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)
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.
Use :
=Date(Max({<MonthNumber={$(=max(MonthNumber)-1)},Month= ,Year= >}Date),'MMM-YYYY')
Its working!!!!
Thank you ☺ ☺
Much appreciated
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),'$ ,###.##')