QS How to create Visual Cues when value is higher it color black group color Dark Blue and lower value with Light Blue ?

[paulyeo11]

Hi All

I need to PE and EPS and Current Ratio automatic give the coloring.

For example if user select APPLE and Google.

Make those higher value items row with Dark Blue and those with lower value Light Blue , so user can see the different , and know google stock is better then apple.

Paul

[shraddha_g]

Remove '=' sign from inside Aggr()

if( $(vEPS) = max(aggr($(vEPS),COMPETITOR_k)) , rgb() ,

          if($(vEPS) = min(aggr($(vEPS),COMPETITOR_k)) , rgb() , white())

[paulyeo11]

Hi Shraddha

I think still have some error on the expression , as it still display blank.

Paul

[shraddha_g]

Have you checked what are the values for   max(aggr($(vEPS),COMPETITOR_k)) and  min(aggr($(vEPS),COMPETITOR_k))

[paulyeo11]

Hi Shraddha

For below expression :-

min(aggr($(vEPS),COMPETITOR_k))

it also return null value.

Paul

Re: QS How to create Visual Cues when value is higher it color black group color Dark Blue and lower...