Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!