topic Re: How to color a text-string in QlikView

How to color a text-string

Mon, 24 Aug 2015 08:00:07 GMT

Hi,

I want to have a text-string which is under a certain condition coloured. As in my example the text "open-delay" should come up in red and bolt.

Could someone help me how to achieve this on the easiest way?

Thx in advance

Heiko

Re: How to color a text-string

pokassov — Mon, 24 Aug 2015 08:06:48 GMT

Hi!

See image.

Re: How to color a text-string

alex_millan — Mon, 24 Aug 2015 08:08:26 GMT

Hi Heiko,

if this is a result of an expression, you can format the text colour in the chart properties windows --> tab expressions --> select your expression and click the plus sign on its left, then in the text colour window you can put a conditional expression to set the colour. For example = if(status = 'open-in-time',RGB(10,10,10),RGB(0,0,0))

HTH

Regards

Re: How to color a text-string

mustafaelryah — Mon, 24 Aug 2015 08:09:24 GMT

My Dear

1.Properaties

2.Font Tab

3.Double click on the color and choose calculated

4.Type the formula that you want as below:

=if ((Sum(balance)>=0, RGB (255,255,255),RGB(255,255,255))

Re: How to color a text-string

Mon, 24 Aug 2015 08:34:56 GMT

perfect,

thank you