topic Override Chart Axis Labels in QlikView

Override Chart Axis Labels

Thu, 30 Apr 2009 19:58:33 GMT

Is there a way to override the axis (X,Y) labels on a Bar Chart? At the moment the labels default to the value of the dimension used.

I would like to substitute another value but can't see how this might be accomplished.

Override Chart Axis Labels

Thu, 30 Apr 2009 20:02:36 GMT

When you select dimension you can set the label name. Its to the right of the popup screen and called "Settings for selected dimension" or something like that. There you can check "label" and type in your prefered text.

Override Chart Axis Labels

Thu, 30 Apr 2009 20:05:01 GMT

Or did you mean that you want to change all values displayed on the axis to something else? If that's the case I would just create a new field in the script with the corresponding values that I want to display based on the "real" dimension.

/Fredrik

Override Chart Axis Labels

Thu, 30 Apr 2009 21:02:42 GMT

Not quite what I wanted. The 'Settings for Selected Dimension' options allow me to change the Title of the Axis but not the individual Axis (legend) values. These are coming from the Dimension.

Here is the problem;

The data values are system, catalogue, score

App1 - 2 - 90

App1 - 5 - 91

App1 - 6 - 94

App2 - 2 - 89

At the moment the catalogue is the dimension and so individual axis labels are 2, 5, 6, 2.

So the resulting bargraph has 4 bars and the values are 90, 91, 94, 89

I just want the axis labels to be App1, App1, App1, App2 and not 2, 5, 6, 2

Override Chart Axis Labels

Thu, 30 Apr 2009 21:19:35 GMT

Hmm. I don't know how to deal with the fact that QV would group all App1 entries as one bar.

You get half the way by setting the dimension to App1 & '-' & catalogue but then of course the legend would be App1-2, App1-5 etcetera which might look ugly.

Override Chart Axis Labels

Oleg_Troyansky — Thu, 30 Apr 2009 23:23:28 GMT

You can use a calculated dimension using function Dual:

Dual(Text, Number)

The Text will be displayed on the axis, but the Number will be used for aggregation, etc... This should do what you wanted.

good luck!

Oleg

Override Chart Axis Labels

Anonymous — Fri, 01 May 2009 00:35:36 GMT

Speaking of dual - how QV will handle the situation with the same text (App1) but different numbers?

Override Chart Axis Labels

Oleg_Troyansky — Fri, 01 May 2009 01:21:52 GMT

I did a quick test and what I found was - you see the same label several times, but separate chart points, which is exactly what was required. So, the text is used for the labels and the number is used for determining the chart points.

Override Chart Axis Labels

yblake — Fri, 01 May 2009 02:38:17 GMT

This is really a perfect trick... but it's definitely an ergonomy fall ! assuming that users are human beeing, i would try to avoid that. If this is what they want after all, make sure this is not a application for a nuclear plant 😉

Override Chart Axis Labels

Fri, 01 May 2009 13:53:30 GMT

Oleg,

Thanks very much. This works perfectly.

It isn't for a nuclear plant so we should be OK.