topic Text Color in Expresson in QlikView

Text Color in Expresson

Mon, 14 Mar 2011 09:12:45 GMT

I change Text Color for expression by

if($(woutt)=0,white(),black()) and I I couldn't see a caption for this expression. Any ideas?

Text Color in Expresson

amars — Mon, 14 Mar 2011 09:24:11 GMT

Try using it this way

if($(woutt)=0,RGB(0, 0, 0),RGB(255, 255, 255))

Thanks....

Text Color in Expresson

Mon, 14 Mar 2011 09:46:15 GMT

So sad, but it don't works too

Text Color in Expresson

Mon, 14 Mar 2011 10:56:13 GMT

=if((sum({$<YEAR={"1997"}>}Quantity)+ sum({$<YEAR={"1997"}>}Quantity)*bc) -( sum({$<YEAR={"1996"}>}Quantity))<0,rgb(255,0,0))

Text Color in Expresson

Mon, 14 Mar 2011 17:23:37 GMT

The column label is taking on the text color of the top row. That always happens if you use an expression for text or background color. I don't know if anyone has ever found a good workaround for it (QlikView does not consider it a bug). If you can figure out a way to have a dummy first row with black text then the column label should appear.

AW:Re: Text Color in Expresson

brenner_martina — Mon, 14 Mar 2011 18:03:35 GMT

Hi,

I really have no workarround, if you can live with this:

If(RowNo()>1 and conditions... , White(),Black())

or work with Dimensionality() and let the Partial Sums on Top

Re: Text Color in Expresson

Fri, 08 Aug 2014 13:53:36 GMT

How to do the text formatting through expression in QlikView?

For example: Pipeline (letter ‘P’ alone should be in blue color & bold).

Re: Text Color in Expresson

Fri, 08 Aug 2014 14:04:39 GMT

if(woutt=0,white(),black()) nothing $ or

if('$(woutt)'=0,white(),black())

Re: Text Color in Expresson

Sat, 09 Aug 2014 06:34:49 GMT

Hi,

Try it via Visual Cues in chart properties