Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Creator

## Pie chart color

 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,

1 Solution

Accepted Solutions

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Thank you.

Community Browser