How to make lowest 3 bars in a bar chart to be red color?

[s10157754]

Dear Qlikview Expert,

I know this might be easy for you but I have faced difficulties in writing conditional syntax under (expression tab->expression->background color to sort my lowest 3 bars in a bar chart to be in RED color. The picture below shows how my bar chart looks like. 

In my bar chart, I only have 1 dimension (Product Number) and 1 expression (Success Rate).

However my expression is a fraction. E.g. ((count(valueA) / count(valueB) + count(valueC))*100)

So in this case, I would like to show product number 149, 109 & 163 to be in Red color, any ideas from you would be greatly appreciated!  

Best Regards,

Qian Ning

[sunny_talwar · Accepted solution]

Use this in your background color expression

If(Rank(-((count(valueA) / count(valueB) + count(valueC))*100)) < 4, LightRed(), Yellow())

Update: Note a small minus before the actual expression inside the Rank() function

[vishsaggi]

May be try this in your background color expr:

= IF(((count(valueA) / count(valueB) + count(valueC))*100) < Min(((count(valueA) / count(valueB) + count(valueC))*100), 4), LightRed(), LightBlue())

[prat1507]

Use

=if(rank(- ((count(valueA) / count(valueB) + count(valueC))*100),Product Number)<=3,red(),blue())

[s10157754]

Thanks Sunny,

Your solution works perfectly for me! Thank you so much for your precious time!

Best Regards,

Qian Ning