Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Color Expression

Hello:

I've this color expression = IF (Sum(Visits) > 200000, Blue(), Green()) and it works fine.

Now I need to change it by another one thar prints in blue the top five values and in green other values which conpletes the list.

Thank you

1 Solution

Accepted Solutions
Not applicable

Hi,

use something like this

= if(Rank(Total Sum(Visits))<=5,Blue(),Green())

View solution in original post

2 Replies
Not applicable

Hi,

use something like this

= if(Rank(Total Sum(Visits))<=5,Blue(),Green())

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Thank you Vivek.

This is the solution