6 Replies Latest reply: Oct 18, 2016 1:51 AM by Yeo Poh sai

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

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

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

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 )))))))

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

Hi Shra

Thank you for your sharing. Not working.

Paul

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

can you share the app?

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

My QVF

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

Hi,

Please check attached app. Its working.

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

Thank you very much ! !