Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
apthansh
Contributor

Pie chart color

TypePercentRedAmberGreen
Cost4.33%Above 5%0-5%Under 0%
Quality9.33%Below 3%3-6%Above 6%
Availability6.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

Re: Pie chart color

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

Re: Pie chart color

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)
apthansh
Contributor

Re: Pie chart color

Thank you.