Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

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
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
apthansh
Creator
Creator
Author

Thank you.