Map - Coloring countries according to Territory

[#1]

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)))))

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. 

[#2 · Accepted solution]

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