topic Re: Change Text Format of Values on Data Points in QlikView

Change Text Format of Values on Data Points

danielle_v — Wed, 02 Oct 2013 11:15:47 GMT

Hi All,

I have a stacked bar chart as per the below, in which there are values on the data points. my issue is that the the black font is difficult to ready against the dark blue bars. If I change the font to white, this then becomes difficult to read against the light blue bars. I am unable to change the colours used for the bars as these colours are required.

Is there any way of changing the text colour for some of the values - e.g. change the values on the last 2 bars to white so that they are easier to read, and leave the rest as black? Or is there an option to outline the values, which may help the colours stand out? Or if anyone has any other solutions, I would be greatful for any help!

I have tried an expression based on an IF statement in Expression -> Text Colour, but this didn't seem to change anything.

Thanks in advance!

Re: Change Text Format of Values on Data Points

Clever_Anjos — Wed, 02 Oct 2013 11:32:52 GMT

At Expressions tab, expand symbol your expression.

Set an expression to 'font-color' for each dimension value

an example:

if(rowno() > 5, white(), black())

Re: Change Text Format of Values on Data Points

Anonymous — Wed, 02 Oct 2013 14:43:56 GMT

Hello Denielle,

here is na example attached.

What I did, was to use to inversed colormix:

1 for the background, going from the light blue to dark blue,

and the inverse to the text ( going from black, to White ).

So, the lighter is the chart, the darker is the text

Please, see if it is helpfull.

Re: Change Text Format of Values on Data Points

Wed, 02 Oct 2013 19:55:04 GMT

Very tricky

thanks Lucas

Re: Re: Change Text Format of Values on Data Points

Anonymous — Thu, 03 Oct 2013 00:59:01 GMT

Thanks Jean-Jacques

Of course, it requires a special treatment to the values to close to the middle ( between 40% and 60% ), because in those cases, the colors get to close ( as showed in the Picture ).

But that can be done with simple conditional ( if values close, black(), else color expression. )

Re: Change Text Format of Values on Data Points

danielle_v — Thu, 03 Oct 2013 07:33:44 GMT

Hi Lucas and Anjos,

Thank you both so much for your help!

Both of your answers were really helpful, in the end I went for the rowno solution.

Thanks again!