Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Not applicable

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

1 Solution

Accepted Solutions
shraddha_g
Not applicable

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

Hi,

Please check attached app. Its working.

6 Replies
shraddha_g
Not applicable

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

I hope it is helpful.

paulyeo11
Not applicable

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

shraddha_g
Not applicable

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

can you share the app?

paulyeo11
Not applicable

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

My QVF

shraddha_g
Not applicable

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

Hi,

Please check attached app. Its working.

paulyeo11
Not applicable

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

Thank you very much ! !