topic Re: Bar Graph Display Issue when using LOG SCALE axis in QlikView

Bar Graph Display Issue when using LOG SCALE axis

tschullo — Fri, 30 Oct 2015 14:25:49 GMT

In the above chart, note that the number at the end of the top bar has been truncated.

This goes away if I make the chart much wider and gets worse as I make it narrower.

As you can see in the pop-up it should be 4012.

I have worked around this elsewhere by setting a "Static Max" in the Axes tab of the Properties of the chart.

10,000 might work in this instance.

In this case becasue it is a drill down, my log scale changes as I drill down.

So I got the idea to use an expression for the "Static Max" such as

=Count(DISTINCT N_RESULT_KEY) Which would be the numnber represented by the total of all bars.

This works most of the time but not always.

My question is: Has anyone else run into this and how did they solve it?

I'm thinking finding the value of the first bar and multiplying it by 1.5 or 2, something like this:

=FirstSortedValue(Count(DISTINCT N_RESULT_KEY),Count(DISTINCT N_RESULT_KEY))*2

Theproblem is I don't quite understands how FirstSortedValue should be used in this case, it isn't working.

Any ideas?

Re: Bar Graph Display Issue when using LOG SCALE axis

Gysbert_Wassenaar — Fri, 30 Oct 2015 14:44:45 GMT

Don't display the values on top of the bars, but use Text on Axis so that the values are shown in front of the bars. You'll probably need to resize the plot area a bit so these values don't overlap with the bar labels.Press the CTRL+SHIFT keys at the same time and you'll see red outlines around the chart elements. You can resize/move those red outlines.

Re: Bar Graph Display Issue when using LOG SCALE axis

jonathandienst — Fri, 30 Oct 2015 14:48:24 GMT

Rather than FirstSortedValue, I suggest Max(Aggr()) like this:

=Max(Aggr(Count(DISTINCT N_RESULT_KEY), [Business Line]))

(assuming Business Line is the dimension).

Have you tried displaying the value on the x-axis instead of on the bars?

Re: Bar Graph Display Issue when using LOG SCALE axis

tschullo — Fri, 30 Oct 2015 14:48:43 GMT

That would work, but sometimes I don;t want the numbers on the axis.

Are we saying there is no solution?

Re: Bar Graph Display Issue when using LOG SCALE axis

Gysbert_Wassenaar — Fri, 30 Oct 2015 14:55:30 GMT

There are always solutions. The question is if you're willing to pay the price .

You can try what jontydkpi‌ suggests. Except I would add a bit to it. Perhaps multiple the result by 2 since you're using a log scale. That gives you a bit more space for the text of the value.

Re: Bar Graph Display Issue when using LOG SCALE axis

tschullo — Fri, 30 Oct 2015 15:03:59 GMT

=Max(Aggr(Count(DISTINCT N_RESULT_KEY), GetCurrentField(LOB_CNTRLO_ApplGrp))) * 2

So, since I am in a Group, I added the GetCurrentField bit but this did not work... any ideas?

Re: Bar Graph Display Issue when using LOG SCALE axis

tschullo — Fri, 30 Oct 2015 15:17:31 GMT

If I went with numbers on axis, I can't for the life of me find where I can change the font color on them ...

Re: Bar Graph Display Issue when using LOG SCALE axis

tschullo — Fri, 30 Oct 2015 15:19:20 GMT

Never mind, I found it... under Text Color of expression in Expressions tab