Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
use something like this
= if(Rank(Total Sum(Visits))<=5,Blue(),Green())
Thank you Vivek.
This is the solution