Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
With month selection:
Any help on how to achieve the same when month is selected? Why the below function doesn't work in this case?
Try this :
sum(aggr(
(sum({<Month>}Measure)-above(sum({<Month>}Measure)))
/
above(sum({<Month>}Measure))
,Month))
Result :
Without selecting :
I select a month, 8 for example :
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?
Also, I'm building over an existing dashboard in consumption and don't have rights to create new measures and variable.
what's in ur variable? can u share? + is your month dimension named Month?