Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
User0
Contributor III
Contributor III

Growth/Decline formula not showing all years

Hi , 
I have to calculate growth for two brands X and Y and I have used the formula 

=(Sum(Volume)/Below(Sum(Volume)) - 1) 

but it is missing data for the last year in the graph.
Currently the selected years are 2022,2021 and 2020.

User0_0-1656575305212.png

 

Labels (6)
2 Replies
Or
MVP
MVP

Below(Sum(Volume)) will return null for 2020, since 2019 is not selected, so the entire formula correctly evaluates to null and no value is returned.

 

User0
Contributor III
Contributor III
Author

I understood.
Is there any other way to calculate the growth/decline so that I can see the result for all the selected years?