topic Re: Assign a Color to a Dimension which is Text in App Development

Assign a Color to a Dimension which is Text

Fri, 20 Nov 2015 16:11:14 GMT

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

Re: Assign a Color to a Dimension which is Text

JonnyPoole — Fri, 20 Nov 2015 16:56:51 GMT

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

Re: Assign a Color to a Dimension which is Text

Fri, 20 Nov 2015 17:12:13 GMT

That has worked perfectly Thank you