topic Color Expression in QlikView

Color Expression

Joaquin_Lazaro — Mon, 28 Jul 2014 07:17:19 GMT

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

Mon, 28 Jul 2014 07:21:37 GMT

Hi,

use something like this

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

Joaquin_Lazaro — Mon, 28 Jul 2014 07:28:26 GMT

Thank you Vivek.

This is the solution