Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Omkar13
Contributor III
Contributor III

How do I calculate month on month growth for a selected value?

Hi Qlik Experts,

I want to calculate month on month growth for volume in my dashboard.

Currently I'm using expression: =(($(m72) - Below($(m72)))/below($(m72)))*100

and getting desired results but this doesn't work when a month is selected.

Without month selection:

Omkar13_0-1620696183496.png

With month selection:

Omkar13_1-1620696309293.png

 Any help on how to achieve the same when month is selected? Why the below function doesn't work in this case?

 

3 Replies
OmarBenSalem

Try this :

sum(aggr(

(sum({<Month>}Measure)-above(sum({<Month>}Measure)))
/
above(sum({<Month>}Measure))

,Month))

 

Result : 

Without selecting : 

Capture.PNG

 

I select a month, 8 for example : 

Capture.PNG

Omkar13
Contributor III
Contributor III
Author

Thanks for your reply @OmarBenSalem 

I tried your provided expression but its not working for me.

=sum(aggr(

(sum({<Month>}$(m72))-above(sum({<Month>}$(m72))))
/
above(sum({<Month>}$(m72)))

,Month))

Is it because I m working with a variable and not measure? Any idea why this is not working for me?

Omkar13_0-1620778895208.png

 

Also, I'm building over an existing dashboard in consumption and don't have rights to create new measures and variable. 

OmarBenSalem

what's in ur variable? can u share? + is your month dimension named Month?