Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Try using it this way
if($(woutt)=0,RGB(0, 0, 0),RGB(255, 255, 255))
Thanks....
So sad, but it don't works too
=if((sum({$<YEAR={"1997"}>}Quantity)+ sum({$<YEAR={"1997"}>}Quantity)*bc) -( sum({$<YEAR={"1996"}>}Quantity))<0,rgb(255,0,0))
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.
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
How to do the text formatting through expression in QlikView?
For example: Pipeline (letter ‘P’ alone should be in blue color & bold).
if(woutt=0,white(),black()) nothing $ or
if('$(woutt)'=0,white(),black())
Hi,
Try it via Visual Cues in chart properties