Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YoY (Year over year growth) by month

I'm trying to accomplish calculating and visualizing YoY growth. I can get the growth from the previous year to the max year (eg 2013 -> 2014, bottom graph) with this:

=((sum({$<Year = {$(=max(Year))}>}Sales) - sum({$<Year ={$(=max(Year)-1)}>}Sales))/ sum({$<Year = {$(=max(Year)-1)}>}Sales)) * 100

...but what would be the function to get it for all the years in the past (here: 2011 -> 2012 & 2012 -> 2013)

Qlik.png

22 Replies
Not applicable
Author

Thanks so much Sunny for looking into this! Your answer works, but I marked Settu's answer as the solution since it is so compact (less code).

Not applicable
Author

Thanks Settu!

Only now that Sunny put his solution did I notice that your solution did it. I previously forgot to put the Year into dimensions.

isingh30
Specialist
Specialist

Hello Settu,

What -1 is doing?

Thank you!