Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

joaquinlr
Valued Contributor 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

Re: Color Expression

Hi,

use something like this

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

2 Replies
Not applicable

Re: Color Expression

Hi,

use something like this

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

joaquinlr
Valued Contributor II

Re: Color Expression

Thank you Vivek.

This is the solution

Community Browser