Map colors by top 10 ranking

[ameydiwanji]

Hi all,

I am using custom colours ( colour by expression) in map objects. I want to show my top scoring locations  in red colour and other in green colour how can I do that? So basically I am using sum function, rank function and if function. But I am not getting the desired result? I am using qlik sense 3.0 with below expression

If((Rank(sum(([Rank 1 ]*[Weightage1)+([Rank 2]*[Weight 2])),0,Location))<=10,rgb(150,0,0),rgb(0,125,125))

Please help to correct this expression

[Anonymous]

Hi

May be like this ?

=if(Aggr(Rank(Sum(score)), location)<=10,

      rgb(150,0,0),

          rgb(0,125,125))

[millan123]

Hello,

Sum(Aggr(If(Rank(Sum(Sales), 1),Red(),Green()) Location)) it helps you

[MK9885]

=if(

  (sum(Sales)&Location))<10,rgb(150,0,0),

  if(

  (sum(Sales)&Location))>10,rgb(0,125,125)

  ))