Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this expression, in the Calculated Color
Pick(Match(String,'Critical','High','Moderate','Low'),Red(),Yellow(),Green(),Blue())
Try this expression, in the Calculated Color
Pick(Match(String,'Critical','High','Moderate','Low'),Red(),Yellow(),Green(),Blue())
Thanks @Saravanan_Desingh I will see if this expression also work with qlik sense. Appreciate it
@Saravanan_Desingh It worked😁. Thanks, I have more ways to highlight text now. 😍