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
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
brandon_d
Contributor III
Contributor III

Pie Chart with Measure within the Dimension

I am attempting to display a pie chart that has the count within the pie chart and then the % as part of my dimension. For example, if SHER has a count of 37 and CENT has a could of 287, I would want the pie chart to display those values within the chart and then the labels say SHER: 11.4% and CENT: 88.6%. However, I am not having any luck at achieving this.

My measure is as follows:  Sum(Aggr(If(Sum({$<RenFlag = {1}, SurgeryFlag = {1}, [_R12M] = {1}, TJFlag = {0}, [Rendering Doctor Name] = {'Test, Provider'}, SurgAssistFlag = {1}>} Units)>0, 1, 0), Key|Surgery, [Rendering Doctor Name], [Invoice Date]))

My dimension is: [Facility Group Name]

 

clipboard_image_0.png

1 Solution

Accepted Solutions
sunny_talwar

May be this as your dimension

Aggr(

[Facility Group Name]
& ': ' &
Num(Sum(Aggr(If(Sum({$<RenFlag = {1}, SurgeryFlag = {1}, [_R12M] = {1}, TJFlag = {0}, [Rendering Doctor Name] = {'Test, Provider'}, SurgAssistFlag = {1}>} Units)>0, 1, 0), Key|Surgery, [Rendering Doctor Name], [Invoice Date]))/Sum(TOTAL Aggr(If(Sum({$<RenFlag = {1}, SurgeryFlag = {1}, [_R12M] = {1}, TJFlag = {0}, [Rendering Doctor Name] = {'Test, Provider'}, SurgAssistFlag = {1}>} Units)>0, 1, 0), Key|Surgery, [Rendering Doctor Name], [Invoice Date])), '##.#%')

, [Facility Group Name])

View solution in original post

2 Replies
sunny_talwar

May be this as your dimension

Aggr(

[Facility Group Name]
& ': ' &
Num(Sum(Aggr(If(Sum({$<RenFlag = {1}, SurgeryFlag = {1}, [_R12M] = {1}, TJFlag = {0}, [Rendering Doctor Name] = {'Test, Provider'}, SurgAssistFlag = {1}>} Units)>0, 1, 0), Key|Surgery, [Rendering Doctor Name], [Invoice Date]))/Sum(TOTAL Aggr(If(Sum({$<RenFlag = {1}, SurgeryFlag = {1}, [_R12M] = {1}, TJFlag = {0}, [Rendering Doctor Name] = {'Test, Provider'}, SurgAssistFlag = {1}>} Units)>0, 1, 0), Key|Surgery, [Rendering Doctor Name], [Invoice Date])), '##.#%')

, [Facility Group Name])
brandon_d
Contributor III
Contributor III
Author

Thank you so much, this is perfect!