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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kevbrown
Creator II
Creator II

Pie Chart Colours

Hi,

I have a pie chart that is looking at waiting times. So, simply, bandings of 0-4, 4-8, 8-12, 12+. Colours are set but i would like the 12+ banding section to be green when it's less than 10% of all waiting times and red when more than 10%, how?

18 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Can  you sample file ?

tchovanec
Creator II
Creator II

Kevin, The first thing I would do is not use a Pie Chart. Studies have been done that show this chart is difficult to understand. Instead I would us e a stacked bar chart or just a regular bar chart. Then under your expression, you can expand it to show background color, There you can set something like

IF(sum(BANDING)>12,green())

Capture.PNG

Not applicable

A sample qvw would help but a possibility would be to use the the background color for your expression - in this ara you would code what you want the colors to be

kevbrown
Creator II
Creator II
Author

File attached

Not applicable

I do not see any data loaded in the application - can you please reload, include the pie chart with your desired banding and re-attach - thanks

kevbrown
Creator II
Creator II
Author

Sorry my mistake, try again

tchovanec
Creator II
Creator II

Try this. I updated the background color on the expression.

Not applicable

It looks like there are a total of 25 patients and 17 of them are in the 12+ category.  The percent would need to be determined (17/25). which is 68% - If I understand correctly, this section of the pie (or the bar if you switch to a bar char) should be red?  If the percent was less than 10% then this section of the pie (or bar) should be green?

kevbrown
Creator II
Creator II
Author

Yes that's correct in what you're saying