topic Re: Color Expression by Year (If Statements) in QlikView

Color Expression by Year (If Statements)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Color Expression by Year (If Statements)

Anil_Babu_Samineni — Mon, 11 Sep 2017 16:21:05 GMT

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

Re: Color Expression by Year (If Statements)

sunny_talwar — Mon, 11 Sep 2017 16:21:08 GMT

Try this

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

Re: Color Expression by Year (If Statements)

Anonymous — Mon, 11 Sep 2017 16:59:15 GMT

That worked!

Thank you!!