expression colours

[Dolly123]

color by expression 

SOUTH - RED

NORTH - GREEN

EAST - BLUE

WEST - YELLOW

I want to write the expression for colours 

any one can help me ?

[MayilVahanan · Accepted solution]

Hi

Try like below

Pick(match(urfieldname, 'SOUTH', 'NORTH', 'EAST', 'WEST'), Red(), Green(), blue(), Yellow())

[Dolly123]

i have some extra NA and or more than than how to add in this expression

[MayilVahanan]

Try like below

Pick(match(urfieldname, 'SOUTH', 'NORTH', 'EAST', 'WEST')+1, LightGray(), Red(), Green(), blue(), Yellow())

[Dolly123]

3 or 4 extra NA,MA,TR etc 

if extra things in data how to changes in expression like this

Pick(match(urfieldname, 'SOUTH', 'NORTH', 'EAST', 'WEST')+3,pink(),black(), LightGray(), Red(), Green(), blue(), Yellow())

[Dolly123]

If there is not name of region then how to apply colours if no name

[MayilVahanan]

Hi

Try like below

Pick(match(Coalesce(urfieldname, 'NA'), 'NA', 'MA', 'TR', 'SOUTH', 'NORTH', 'EAST', 'WEST'),pink(),black(), LightGray(), Red(), Green(), blue(), Yellow())

Coalesce() - return non-null values