topic Re: Expression to background color specific text values in Visualization and Usability

Expression to background color specific text values

Anonymous — Wed, 28 Feb 2018 01:25:40 GMT

Hello All-

Fairly new to Qlik Sense, and trying to create a background color expression for cells in a column.

My general layout is this, with the column heading Status. I want to color certain Status text names green, lets say Status A, Status B, and Status C, but leave the other Statuses white.

Status

Status A

Status B

Status C

Status D

Status E

My current expression is something like:

if([Status]='Status A' OR 'Status B' OR 'Status C', green())

The problem that I am running into is that only "Status A" is showing up green.

Re: Expression to background color specific text values

Thiago_Justen_ — Wed, 28 Feb 2018 02:10:55 GMT

Try this out:

if([Status]='Status A' OR [Status]= 'Status B' OR [Status]= 'Status C', green())

Re: Expression to background color specific text values

yujiyamane — Wed, 28 Feb 2018 04:00:21 GMT

It should be as below. Please find the attachment for the example.

if([Status]='Status A' OR [Status]= 'Status B' OR [Status]= 'Status C', green())

Re: Expression to background color specific text values

Anonymous — Wed, 28 Feb 2018 16:58:31 GMT

Awesome, this worked great. Now what if I want to make them different colors, say making Status A and Status B green but make Status C red?

Re: Expression to background color specific text values

Thiago_Justen_ — Wed, 28 Feb 2018 17:10:59 GMT

You could do it:

Pick(WildMatch(Status, 'Status A', 'Status B', 'Status C'),green(),green(),red())

if([Status]='Status A' OR [Status]= 'Status B',green(),red())

Re: Expression to background color specific text values

yujiyamane — Wed, 28 Feb 2018 20:57:45 GMT

It should be like below. (You just need two if statements)

if([Status]='Status A' OR [Status]= 'Status B', green(),

if([Status]= 'Status C', red())

)