Color Expression by Year (If Statements)

[Anonymous]

I am trying to create and If statement that allows me to use the color expression function to color by specific year. I have come close to a solution, but not as I'd like it to be. (color codes are just examples)

This gets me a color for the first year, and all other years get the second. Its a start.

if([Service Year] = 2017, argb(255,1,149,189), argb(255,1,179,169))

What I'd like to see is:

IF([Service Year] = 2017, argb(255,1,149,189),

IF[Service Year] = '2016', argb(255,1,179,169)),

IF([Service Year] = '2015', argb(255,40,39,171)),

Etc..

Has anyone tried something similar to this?

Thanks

[Anil_Babu_Samineni]

Try from your end and tell us how you are getting the combination of nested if statements

[sunny_talwar · Accepted solution]

Try this

Pick(Match([Service Year], 2017, 2016, 2015), ARGB(255,1,149,189), ARGB(255,1,179,169), ARGB(255,40,39,171))

[Anonymous]

That worked!

Thank you!!