Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
newbie_sm
Contributor III
Contributor III

How to calculate year 2022 volume as a percentage of year 2019 volume?

How to calculate 2022, 2021 & 2020 volume as a percentage of 2019 volume?

Sum({<YEAR>}Volume)/Sum({<YEAR={'2019'}>}Volume) don't work

Labels (1)
2 Replies
justISO
Specialist
Specialist

Hi, maybe:

sum(Volume) / Sum(total {<YEAR={'2019'}>}Volume)

newbie_sm
Contributor III
Contributor III
Author

thanks! it works