Create a MoM % sales change KPI

[zedmo]

Hi! I am trying to have a % change month over month kpi indicator for sales, based on the selection of a date.

I am thinking on using set analysis for this, to grab the max of current month minus max of current month -1.

However I would lik to know if any of you have a simple way to calculate MoM %

Any help would be appreciated!

[Zapparoli]

So, your solution is actually correct and looks simple for me.

If your application needs to use more complex operations using month over months, rolling averages of some sort, you can use a AsOfCalendar.

You can learn it more in this article made by HIC: https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

In your scenario I would stay with your solution.

Something like this, would do the trick.

Addmonths(Max(Date),0)
/
Addmonths(Max(Date),-1)

Hope this helps.

-Zapparoli