Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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