Calculating MOM and YOY in a qliksense KPI

[Aspiring_Developer]

Hello All,

I need to achieve below :-

1) YOY and MOM

2) Show these values in KPI and up and down arrows like below :-

I am able to calculate YOY but facing issue in MOM. PFB the expression :-

=(Sum({<Month=, Date=, Brand ={'Plusnet'},MonthName={'$(=MaxString(MonthName))'}>} Value)

-

Sum({<Brand ={'Plusnet'},Month=, Date=, MonthName={'$(=(MaxString(MonthName) -1))'}>} Value))

/

Sum({<Brand ={'Plusnet'},Month=, Date=, MonthName={'$(=MaxString(MonthName))'}>} Value)

This expression gives me in correct result and when I checked the variable values ,I found that for max month it is showing Apr-2022 but for previous month (i.e max(month)-1) gives me month in number format. Here are my fields:-

Can anyone please help ? 

Thanks in advance

[Or]

MaxString(MonthName)-1 is not "The month before the current month". It is the last day of the month previous to MonthName (the first of the month minus one day).

Try using AddMonths(MonthName,-1) instead, or applying MonthName(MonthName-1).