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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get 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%')