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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate % of a total

I am trying to create a calculation that gives me this year % of business. How would I do that using the example below:

BrandCustomer$ Amount% of Business
XYZCustomer A500.31
XYZCustomer B250.16
XYZCustomer C350.22
XYZCustomer D500.31
Sum XYZ160


I'm trying to figure out how to use an expression to calculate the last column. It has to be able to be dynamic based on the date/year selected.

Thanks!

1 Reply
Not applicable
Author

Sum(Amount) / Sum(Total Amount)