Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ameydiwanji
New Contributor II

Map colors by top 10 ranking

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

3 Replies
galax_allu
Valued Contributor

Re: Map colors by top 10 ranking

Hi

May be like this ?

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

      rgb(150,0,0),

          rgb(0,125,125))

millan123
Contributor II

Re: Map colors by top 10 ranking

Hello,

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

Khan_Mohammed
Honored Contributor II

Re: Map colors by top 10 ranking

=if(

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

  if(

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

  ))