Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pragya
Creator
Creator

Label and data value together in a pie chart

Hi All, 

I  have a donut chart and the labels are male and female. Now the data values are coming inside the donut chart and the labels are outside the donut chart. Is there any way i can put data values under the label. So i am looking for Female(22.11K) and Male(37.47K)

Pragya_0-1659479257742.png

Thanks

Labels (1)
  • Chart

11 Replies
anthonyj
Creator III
Creator III

It's a good point. Let me try it on the Cloud version.

 

anthonyj
Creator III
Creator III

Okay, so I put this in Qlik Cloud using the standard Pie Chart.

Dummy Data:

Gender:
load * Inline [
Gender, Column
Female, 22000
Female, 1100
Male, 37000
Male, 400
Male, 200

];

Dimension: Slice

=dual(Gender & ' ' & num(AGGR(Count(distinct[Column] ),Gender)/1000,'#,###K')
& ' (' & num(AGGR(Count(distinct[Column] ),Gender)/AGGR(COUNT(total DISTINCT [Column]), Gender),'#0.0%') & ')',
num(AGGR(Count(distinct[Column] ),Gender)/1000,'#,###K') )

Measure: Angle

Count(distinct Column)

Appearance > Presentation > Donut Chart

Value Labels Off

Custom > None

These are the only steps I took in creating the below chart.

anthonyj_0-1659497417816.png

 

You could try simplifying down to just the Dimension and the amount and break it down.

=dual(Gender & ' ' & num(AGGR(Count(distinct[Column] ),Gender)/1000,'#,###K')
,num(AGGR(Count(distinct[Column] ),Gender)/1000,'#,###K') )

I did notice when I copied and pasted the above into the dimension that if it wasn't on the top line it would add an extra "=" sign which caused the same error you saw above. 

Let me know how you go.

Thanks

Anthony