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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ckiesling
Contributor II
Contributor II

Adding Percentages to Pivot Table

How do I add percentages to a pivot table? I have the location and the number of clients at each location, but I want to show this as a percent instead of a count.

Labels (1)
2 Replies
anat
Master
Master

count(clients)/count(total clients)

ckiesling
Contributor II
Contributor II
Author

Although it says the formula is valid, I am getting the same calculation as my previous column which is the total number of people in each facility rather than a percent.