Change text box Bg color based on string values

[Omkar13]

Hi experts,

I want to change the bg color of text box based on String value. I have 4 string values for priority Critical, High, moderate  and Low and bg color are Red, Yellow, Green and blue respectively.

I was able to achieve similar on table values based on measure and adding if condition but it doesn't seems to work with text box bg. Does anyone know a solution for this?

[Omkar13 · Accepted solution]

Solution:

=if(Priority = '2 - High', red(), If(Priority ='1 - Critical', yellow(), If(Priority ='3 - Moderate', green(),If(Priority ='4 - Low', blue()))))

[Saravanan_Desingh · Accepted solution]

Try this expression, in the Calculated Color

Pick(Match(String,'Critical','High','Moderate','Low'),Red(),Yellow(),Green(),Blue())

[Omkar13]

Thanks @Saravanan_Desingh I will see if this expression also work with qlik sense. Appreciate it

[Omkar13]

@Saravanan_Desingh It worked😁. Thanks, I have more ways to highlight text now. 😍