Color the expression according the value

[#1]

Dear all,

I have a straight table where I have a dimension-Store_Name

Expressions-Sales/margin/Net Sale Qty

whenever a measure will be selected the chart will represent the bottom stores based on the measures value-i-e the stores will be sorted in the ascending order.

Now my problem is that I want to color the most bottom store as the darkest color,the color will be lighter when the stores values will be increasing gradually.i-e-If the bottom stores have values 100,200,300,400,500...then 100 will be darkest red,200 will be a little bit lighter,and so on..

Please help.

[MK9885]

Using ColorMix In Qlikview

[Anil_Babu_Samineni]

Try something like this

If(Sum(Sales) = 100, LightRed(), If(Sum(Sales) = 200, ...., LightGreen()))

OR Please post sample application