topic Pie Chart Individual Colors in QlikView

Pie Chart Individual Colors

Tue, 16 Feb 2010 23:52:46 GMT

Hi,

I am using Qlikview 9.0. Is there was a way to change an individual Pie chart color with a given criteria(script)?

What I would like to do is run the Pie chart data thru some script criteria and if one of them meets it then change that particular color to something else.

Thanks,

Mike C.

Pie Chart Individual Colors

johnw — Wed, 17 Feb 2010 00:17:15 GMT

You can enter an expression to select the color in the "Background Color" definition when you click on the + next to the expression. Here's an example expression:

pick(1+match(only(Customer),'Company 1','Company 2'),green(),red(),black())

So company 1's pie slice will be red, company 2's will be black, and the rest will be green. You can use rgb() expressions and other things to specify the colors themselves. I believe that if the expression doesn't assign a color to a pie slice, it will use the a default color from the color tab.

Pie Chart Individual Colors

Wed, 17 Feb 2010 01:11:26 GMT

Thanks for the reply John. I can use that.

Can you provide what's the simpliest formula to use in order to make that color change? I am doing a calculation to pull a percent value and if that value is greater or = (>=) than 60 then change the color.

I was trying this ->

If (round((Count(IF(PPE_EquipmentTestResults='P', PPE_EquipmentTestResults))*100/ Count(PPE_EquipmentTestResults)), .10) >=60,RGB(250,0,0))

Thanks,

Mike C.

Pie Chart Individual Colors

johnw — Wed, 17 Feb 2010 01:27:18 GMT

Well, it's not really any simpler, but it will likely execute faster by using set analysis and avoiding the multiplication and the round() function:

if(count({<PPE_EquipmentTestResults*={'P'}>} PPE_EquipmentTestResults)/count(PPE_EquipmentTestResults)>=.5995,rgb(250,0,0))

Pie Chart Individual Colors

Wed, 17 Feb 2010 19:27:52 GMT

That worked great, Thanks.

I have one more question about the inital pie slice selection. In the example, is the "Customer" related to the dimension or expression?

Thanks,

Mike C.

Pie Chart Individual Colors

johnw — Wed, 17 Feb 2010 19:34:22 GMT

In my example, Customer was the dimension, but I was setting the color for the expression.