Graph label description

[#1]

Dear all,

I have some graphical problem on my chart diagram.

Attached you can see what I need.

Many thanks for every kind suggestion.

Giovanni

[#2 · Accepted solution]

The label from your Drill Down group (Anag_Esami...) can be changed by using Edit Groups on the Dimensions tab. Then, click Edit... and you should have your fields (with a place for labels) under Used Fields.

For your always on top label, can you use a separate Text Box? Build your text box how you want it, drop it on top of the chart and then check the layer properties of each on the Layout tab.

For the long, x-axis labels, I don't know if you can left align them. You can limit the number of characters displayed using the Dimension Limitations on the Presentation tab. Limit Legend Characters to however many you want to see.

As for the labels on the actual chart going off the top, you could try adjusting the size of the chart itself. With the chart selected, hold down Ctrl+Shift and you should get red boxes around each section of your chart. Try resizing the chart area a bit to see if you can fix the items getting cut off. Usually, QlikView tries to redraw the chart based on size, it may be possible to resize the whole chart object a little and see if that helps.

[#3]

Thanks so much for your soon reply.

Giovanni

[johnw]

For a chart like this, I would recommend changing the orientation of the graph: properties -> style -> orientation. Your long labels should then be a lot more readable, as well as it being much clearer which bar they are associated with.

I suspect the numbers are less likely to go off the frame with the new orientation, but I don't know. You can fiddle with the size of the pieces of the chart as NMiller suggests. You could also change the chart axis maximum to give additional space: properties -> axes -> expression axes -> scale -> static max -> max(aggr(your expression,your dimension))*1.1. Fiddle with the last number until you get enough additional room for all of the numbers to display properly.

I'm not seeing any way to left align the labels.

One way to make the labels take less space is to change the text to lower case using capitalize(). You could do that with a calculated dimension, or by adding a second description field. As for limiting the number of characters to, say, 20: properties -> presentation -> dimension limitations -> limit legend (characters) -> 20.

I'm not sure exactly what you mean by changing the description of the labels. If you just mean the description of the level in the drill down group, you should be able to change that by editing the drill down group as NMiller suggests. If you mean the labels themselves, then I'd recommend creating another field in the script with the labels you want.

[#5]

Thanks John very much,

for useful infos.

Giovanni