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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a Total and then all records can use that Total in calculations

I have a list vendors, and they want to show the % represented of that vendor to Total Count.  So the calculation is (Vendor Sum)/(Total Vendors Sum).

How can I show this for each row (for the vendor)?

2 Replies
whiteline
Master II
Master II

If you have only one dimension just use this expression:

=Sum(Vendor)/Sum(total Vendor)

Then go to the Number tab and select Show in Percent checkbox.

Not applicable
Author

Here is a sample.