Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kartik2
Partner - Creator
Partner - Creator

Display Values and Percentage in Pie Chart

I am using Valuelist('Male','Female') as  a dimesion and in measures i'm using  if(Valuelist('Male','Female')='Male',sum(MaleCount),sum(FemaleCount))

This is displaying values but i want to display percentages too 
How can i do that?

Labels (3)
3 Replies
vincent_ardiet_
Specialist
Specialist

Something like this?
if(Valuelist('Male','Female')='Male',sum(MaleCount),sum(FemaleCount))/Rangesum(sum(MaleCount),sum(FemaleCount)))

Kartik2
Partner - Creator
Partner - Creator
Author

Umm .not working

Kartik2
Partner - Creator
Partner - Creator
Author

Ok , got the solution 
i used this in label

'Male'&' : '&sum(Male Count)/num(sum(Male Count)+sum(Female Count),'#0.0%')&' , ' &'Female'&' : '&sum(Female Count)/num(sum(Male Count)+sum(Female Count),'#0.0%')