May i know how make my color display darker color for lowest value ? Now large number color is darker.

[paulyeo11]

Hi All

Below expression work fine , it display the higher value with dark color :-

Colormix1((

$(vPriceBookRatio)

-$(=min(aggr(

$(vPriceBookRatio)

,COMPETITOR_K))))

/

$(=(max(aggr(

$(vPriceBookRatio)

, COMPETITOR_K))

-min(aggr(

$(vPriceBookRatio)

, COMPETITOR_K)))),lightgray(),green())

Now my requirement have change , the smaller value mean better , so How to change the color sequences the other way round ?

Paul

Paul

[shraddha_g · Accepted solution]

Colormix1((

$(vPriceBookRatio)

-$(=min(aggr(

$(vPriceBookRatio)

,COMPETITOR_K))))

/

$(=(max(aggr(

$(vPriceBookRatio)

, COMPETITOR_K))

-min(aggr(

$(vPriceBookRatio)

, COMPETITOR_K)))),green()),lightgray())

[paulyeo11]

my QVF

[paulyeo11]

Wow you are good , with out look at my app , you can directly give me correct answer.