visual cue for a text value

[#1]

I have a text field of either Y or N.  My idea is when the value is Y the field would show up as a GREEN Y and when the value is N the field would show up as a RED N.

I have used visual cues for numeric values but it does not work for text.  Any assistance would be appreciated!

[Anonymous]

Maybe this Workaround is an option

define a variable vText and make use of Input Box

then you may define your TextBox with this variable

you may define in tab Font, the colour to calculated colour like if (vText='Y',rgb(0,255,0),rgb(255,0,0)

[jpenuliar]

Hi John,

Have you tried looking at Expresssion attribute > 'Text Color' ?

Fine Tuning Your Objects - Dimension & Expression Attributes - Living Qlik

[awhitfield · Accepted solution]

Hi John,

you can use the Expression Background Color, eg.

HTH

Andy

[#5]

Thank you for all of the quick replies!  Problem solved....

[Peter_Cammaert]

Is this value displayed in a cell of a Straight Table? Or is it just the content of a Text Box? Whatever value you are showing can be evaluated in an expression to dynmically adjust the cell/text box background/text color.

Peter

[Anonymous]

My Workaround is for textobject

if you have textfield you may use the Solutions of Jonathan or andrew