Calculating MOM and YOY in a qliksense KPI

Aspiring_Developer — Wed, 10 Aug 2022 10:30:57 GMT

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

Re: Calculating MOM and YOY in a qliksense KPI

Or — Wed, 10 Aug 2022 10:46:37 GMT

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).

topic Re: Calculating MOM and YOY in a qliksense KPI in App Development

Calculating MOM and YOY in a qliksense KPI

Re: Calculating MOM and YOY in a qliksense KPI