topic Pie chart color in QlikView

Pie chart color

apthansh — Mon, 13 Nov 2017 13:26:05 GMT

Type	Percent	Red	Amber	Green
Cost	4.33%	Above 5%	0-5%	Under 0%
Quality	9.33%	Below 3%	3-6%	Above 6%
Availability	6.33%	Above 4%	2-4%	Less than 2%

Type is my 3 pies in the pie chart and I have to set the RAG for each pie.Is this possible ?

Thank you,

Re: Pie chart color

Anil_Babu_Samineni — Mon, 13 Nov 2017 13:33:18 GMT

Perhaps this?

If(Type = 'Cost' and Percent > 0.5, Red(), If(Type = 'Cost' and Percent >= 0.0 and Percent <= 0.5, LightGray(), If(Type = 'Quality' and Percent < 0.0, Green(), If(Type = 'Quality' and Percent < 0.3, Red(), If(Type = 'Quality' and Percent >= 0.3 and Percent <= 0.6, LightGray(), If(Type = 'Availability' and Percent > 0.6, Green(), If(Type = 'Availability' and Percent > 0.4, Red(), If(Type = 'Cost' and Percent >= 0.2 and Percent <= 0.4, LightGray(), If(Type = 'Availability' and Percent < 0.2, Green())))))))))

Re: Pie chart color

apthansh — Mon, 13 Nov 2017 14:54:15 GMT

Thank you.