Now my script give me 2 color , How to have more then 3 Color ?

[paulyeo11]

Hi All

Below script from sunny , return 2 color :-

If(Rank($(vEPS)) < 2, 1, 0)

May i know how to modify the color , so that :-

Rank 1 it give Green Color ,

Rank 2 it give Organ Color ,

Rank 3 it give Red Color ,

Hope some one can advise me.

Paul

[shraddha_g]

Pick(Rank($(vEPS)), green(),yellow(),blue(),red(),gray(),lightgray(),cyan())

above expression will work as: if(Rank($(vEPS)) = 1, green(), if(Rank($(vEPS)) = 2, yellow() , if(Rank($(vEPS)) =3, blue(), if(Rank($(vEPS)) = 4, red(), if(Rank($(vEPS)) =5,gray(), if(Rank($(vEPS)) = 6,lightgray(),if(Rank($(vEPS)) = 7 , cyan() and so on )))))))

I hope it is helpful.

[paulyeo11]

Hi Shra

Thank you for your sharing. Not working.

Paul

[shraddha_g]

can you share the app?

[paulyeo11]

My QVF

[shraddha_g · Accepted solution]

Hi,

Please check attached app. Its working.

[paulyeo11]

Thank you very much ! !