topic Re: Pie Chart Colours in QlikView

Pie Chart Colours

kevbrown — Thu, 01 Oct 2015 11:45:20 GMT

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?

Re: Pie Chart Colours

nagarjuna_kotha — Thu, 01 Oct 2015 11:51:04 GMT

Can you sample file ?

Re: Pie Chart Colours

tchovanec — Thu, 01 Oct 2015 11:58:01 GMT

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())

Re: Pie Chart Colours

Thu, 01 Oct 2015 12:08:43 GMT

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

Re: Pie Chart Colours

kevbrown — Thu, 01 Oct 2015 12:25:36 GMT

File attached

Re: Pie Chart Colours

Thu, 01 Oct 2015 12:29:27 GMT

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

Re: Pie Chart Colours

kevbrown — Thu, 01 Oct 2015 13:37:18 GMT

Sorry my mistake, try again

Re: Pie Chart Colours

tchovanec — Thu, 01 Oct 2015 13:49:40 GMT

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

Re: Pie Chart Colours

Thu, 01 Oct 2015 13:56:20 GMT

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?

Re: Pie Chart Colours

kevbrown — Thu, 01 Oct 2015 17:55:11 GMT

Yes that's correct in what you're saying

Re: Pie Chart Colours

kevbrown — Thu, 01 Oct 2015 17:56:01 GMT

I agree that pie charts are rubbish but this is not for one of my reports

Re: Pie Chart Colours

kevbrown — Mon, 05 Oct 2015 09:09:49 GMT

I'm looking for the colour to change. So if, the number of over 12 weeks is more than 10% of the total waits it needs to be red, under 10% then green

Re: Pie Chart Colours

sunilkumarqv — Mon, 05 Oct 2015 09:32:52 GMT

Check attached hopes this helps

Re: Pie Chart Colours

kevbrown — Tue, 13 Oct 2015 13:09:09 GMT

Adam, anymore thoughts on this?

Re: Pie Chart Colours

Tue, 13 Oct 2015 13:14:36 GMT

Kevin

di9d you get a chance to look at waiting times(2) .qvw from Thomas. From what I saw, it looks like it will do what you want - the color is in the expression of the background color

take a look and let me know

Re: Pie Chart Colours

kevbrown — Tue, 13 Oct 2015 13:17:27 GMT

I did look at it but it didn't seem to work, I'll have a play and get it working I'm sure, thanks

Re: Pie Chart Colours

tchovanec — Tue, 13 Oct 2015 13:19:17 GMT

What wasn't working with it?

Re: Pie Chart Colours

Tue, 13 Oct 2015 13:21:03 GMT

my understanding was that you wanted specific colors for each slide and whn you clicked on the slice, the pie would be the color that was selected - from my testing, that is what it was doing

if the requirements are different, please let us know

Re: Pie Chart Colours

kevbrown — Tue, 13 Oct 2015 13:23:28 GMT

Well ideally it needs to be a sum so it dynamically changes. The colours can be standard for the segments, apart from the over 13 which needs to be red is the number of patients waiting over 13 weeks is more than 10% of all patients and green is under 10%, make sense?