Re: Pie chart configuration - Page 2 - Qlik Community

Anonymous · ‎2016-10-04

Hi,

I have a pie chart that looks like this

The number next to the AgeGroup is the number of patients. Questions I have are:

Q1 - How do I include a header to say "NumOfPat"?

Q2 - Is it possible to show the percentage on the pie chart for each age group? For example, blue is about 18%, green

is about 20%.

Thanks!!

mikecrengland · ‎2016-10-04

Gotcha... I don't know of a real way, but you could simply use "Text in Chart" to fake it. Just create the text box and position it with the Control-Shift trick.

Anonymous · ‎2016-10-04

Thanks Michael. Let me play around with it and the CTRL+SHIFT trick. I don't know what it is yet but certainly will be trying to click & press to see if I can get close to what I want.

Anonymous · ‎2016-10-04

I haven't figured it out how to fix the lowest 3 data point labels yet.

Anyone know of a trick so I can see the percentages clearly? See the red arrows.

mikecrengland · ‎2016-10-04

Do they really have to have a Pie Chart? It would be much clearer and cleaner with a horizontal bar chart.

mike

Anonymous · ‎2016-10-04

I did think about whether the lowest 3 data points should be included or not as they aren't playing an

important role in terms of patient targeting. Just thought of something. Maybe I can group the lowest 3 into

"Other" and show this on the pie chart. Let see how it comes out. I will explore the horizontal bar chart as well.

Anonymous · ‎2016-10-04

I think I'm pretty satisfied with this layout now.

One last thing I need to do is to add the header.

Thanks for everyone's help.

mikecrengland · ‎2016-10-05

Try the 'Text in Chart', it's pretty handy.

mike

Anil_Babu_Samineni · ‎2016-10-06

For Q1, Where you want to add the name?

Like Text in chart from presentation tab and then use top right end. Try luck

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2016-10-06

Hi

With that many values on a pie chart I would suggest either as Michael said use dimension limits to combine the lower values as Others or why not use a combination chart to plot the values as bars and the percentage as a line?

Anonymous · ‎2016-10-06

Hi,

Go to Presentation tab> Text in Chart > Align that text box accordingly using CTRL+Shift

Hope it helps!!