Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
That has worked perfectly Thank you