Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Color in Expresson

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?

error loading image

8 Replies
amars
Specialist
Specialist

Hi

Try using it this way

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

Thanks....

Not applicable
Author

So sad, but it don't works too

Not applicable
Author

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

Not applicable
Author

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.

brenner_martina
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

How to do the text formatting through expression in QlikView?

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

Not applicable
Author

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


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


Not applicable
Author

Hi,

Try it via Visual Cues in chart properties