Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Map - Coloring countries according to Territory

Hi,

I have a Qlik Sense map displaying completion rates by country.  Countries are grouped under Territory (USA, Canada and Brazil are all 'Americas').  Currently my color coding is displaying by country, but I would like to have it so all countries in a territory are the same color, e.g. US and Canada would appear as red alongside Brazil.

Color coding summary:

If 100% complete ->Green

If <100% complete -> Orange

If at least one item is past due -> Red

Current color expression:

IF((SumOngoing)/Sum(Total))*>0

                AND (Sum(PastDue)/Sum(Total))=0,rgb(255,128,0),

IF((Sum(PastDue)/Sum(Total))>0,rgb(204,0,0),

IF((SumCompleted)/Sum(Total))=1,rgb(0,153,0),

IF((SumCompleted)/Sum(Total))>1,rgb(0,153,0)))))

Map example.png

What is the best way to achieve this, would this be set analysis or AGGR, and what would be the syntax used?  I tried using Aggr([Current color expression],Territory) but only the red countries retain their color. 

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Map - Coloring countries according to Territory

I believe I got this working.  I used Aggr(NODISTINCT and it seems to have done the trick.

1 Reply
Not applicable

Re: Map - Coloring countries according to Territory

I believe I got this working.  I used Aggr(NODISTINCT and it seems to have done the trick.

Community Browser