Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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