topic Re: Text format of data point values in bar chart not working in QlikView

Text format of data point values in bar chart not working

Thu, 30 Jun 2016 15:29:15 GMT

I have a tilted bar chart as Gantt graph. The bar is displayed by a formula with a dynamic background color, this works fine.

The second formula is to display specific text next to the bars as data point values.

My issue is that no matter how i try to change the formatting of this data point values, nothing changes.

I tried setting the background color, font color or the text format - it always sticks with the default format.

As i plan to change the text format to bold under specific conditions i cant do any global changes. I did make sure its the correct formula, removing the tick "Display Values in Graph" hides them and changing the formula expression does change the displayed value.

Any recommendation on why this maybe doesnt work is appreciated.

Re: Text format of data point values in bar chart not working

stigchel — Thu, 30 Jun 2016 15:46:27 GMT

I once noticed that the the expression attributes did not function when the display line/bar property for this expression was not on. If so turn the display bar/line property on, but set it to invisible.

Re: Text format of data point values in bar chart not working

stigchel — Thu, 30 Jun 2016 15:47:56 GMT

And a screenshot

Re: Text format of data point values in bar chart not working

Fri, 01 Jul 2016 07:21:01 GMT

This is a good idea and im sure this would work under differenct circumstances. However, there are some issues with it.

I do have two formulas. WHile the first one (the bar itself with a value describing the length) works, the second one (label for the bars) doesnt in regard to text formatting.
The second formula only contains the label description. While i can enable it being represented by a bar, it will fill the graph with invalid data.
It is part of a Gantt chart which uses a bar offset on a date representation. If i turn on the bar it will change the offset to zero because of the invalid values, even if its set to invisible, ruining the whole graph.

I feel that this is a good direction anyways and will do some more attempts in this direction. If you have some more ideas id love to hear from it!

Re: Text format of data point values in bar chart not working

stigchel — Thu, 07 Jul 2016 12:12:22 GMT

I'm not quite sure if I can envision what your exact situation is...

But, if I understand that your second formula only contains a label and is therefore displaying invalid data, which although invisible ruins your graph then.. Have you thought about using a Dual() for your second formula?

The Dual has a text representation part, which will be used for the label and a number representation part, which will be used for displaying the bar.

e.g.

Dual('MyLabel',valid data expression)

Re: Text format of data point values in bar chart not working

Thu, 07 Jul 2016 12:20:00 GMT

That sounds like a good idea, if i use Dual in the formula of a bar chart and have "Display values in Graph" it will still show the value length and not the label.