Property table box

carlosban — Wed, 25 Nov 2020 16:16:04 GMT

Property table box

Good, I require the text to be RED (Inoperative) and BLUE (Operative)

Thank you.

Re: Property table box

BalaBhaskar_Qlik — Mon, 30 Jul 2018 07:07:08 GMT

By Using of Table box, Mostly you won't able to get Text color change based on value. You better use Straight table to achieve this.

Or try like this:

You can achieve the same by adding all fields as dimensions, adding one expression, hiding that expression. Then use a formula to set the color. You can use a script:

Load *, Evaluate(Color & '()') as Color2;

LOAD * INLINE

[

Color, Text

Green, ABC

Blue, DEF

Yellow, GHI

];

Use the Color2 field in your dimension / expression background or text color, as is, to set the color.

topic Re: Property table box in QlikView

Property table box

Re: Property table box