How to shade my Top 5 Customers in my Bar Chat with this Rank expression?

[jblomqvist]

Hi all,

I have the following bar chart:

My background colour expression is:

If(Rank(Sum(LineSalesAmount), CompanyName)<=5, LightBlue(), LightGray())

How can I get different shades of blues for my top 5 customers please? E.g. Darkest blue colour for customer ranked 1 and lighter shading up to 5

[sunny_talwar]

May be like this:

If(Rank(Sum(LineSalesAmount)) < 2, LightBlue(250),

If(Rank(Sum(LineSalesAmount)) < 3, LightBlue(210),

If(Rank(Sum(LineSalesAmount)) < 4, LightBlue(170),

If(Rank(Sum(LineSalesAmount)) < 5, LightBlue(130),

If(Rank(Sum(LineSalesAmount)) < 6, LightBlue(90), LightGray())))))

[giakoum]

Using ColorMix In Qlikview