Assign a Color to a Dimension which is Text

[#1]

I have a table of results which are by team so

Team	sent	win	reject
Team B	2000	85	1624
Team F	1245	256	950
Team J	502	100	300

What I want to do Is write an expression where it will color each row by team so for example

Team B = Blue()

Team F = Red()

Team J = Green()

in Qlik Sense what would be the expression I would use in the Background color expression box to accomplish this?

Thanks in advance

[JonnyPoole · Accepted solution]

You can do a color by expression to dynamically evaluate it.

Pick(Match(Team, 'Team B', 'Team F','Team J'), red(), blue(),green())

In this situation the match() function will evaluate every value in the field named 'Team' and is designed to capture 3 possible choices in sequential order:  B, F, J.

Then the pick() function , in order, will swap out a color expression for those 3 values in sequence:   B->red , F->blue etc...

You can do this as a background expression .. YES

[#3]

That has worked perfectly Thank you