topic Re: visual cue for a text value in QlikView

visual cue for a text value

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: visual cue for a text value

Anonymous — Tue, 30 Aug 2016 15:01:12 GMT

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)

Re: visual cue for a text value

jpenuliar — Tue, 30 Aug 2016 15:02:10 GMT

Hi John,

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

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

Re: visual cue for a text value

awhitfield — Tue, 30 Aug 2016 15:03:09 GMT

Hi John,

you can use the Expression Background Color, eg.

HTH

Andy

Re: visual cue for a text value

Tue, 30 Aug 2016 15:05:27 GMT

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

Re: visual cue for a text value

Peter_Cammaert — Tue, 30 Aug 2016 15:05:35 GMT

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

Re: visual cue for a text value

Anonymous — Tue, 30 Aug 2016 15:06:16 GMT

My Workaround is for textobject

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