Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mazilinho
Contributor III
Contributor III

MoM change with aggr

Hello! I am having the following fields: Month, Values, and Region!

I need to display a KPI with the MoM change.

 I use this formula: 

=(Sum({$<[Month2]={"$(=(Max(Month2)))"}>} [KPI Value])-

sum({$<[Month2]={"$(=(AddMonths(Max(Month2), -1)))"}>} [KPI Value]))/sum({$<[Month2]={"$(=(AddMonths(Max(Month2), -1)))"}>} [KPI Value])

What i am trying to add is an if clause inside the formula, to calculate this MoM change when Region='USA' for example.

Can someone please help me with this? Thanks!

Labels (2)
0 Replies