topic Bar chart question in QlikView

Bar chart question

Wed, 08 Dec 2010 19:14:32 GMT

Hi,

I have a bar chart where the dimension values are really long and I'm having trouble getting them to fit inside the chart. I've gone to the axes label in the chart properties and adjusted the primary dimension label but these are long customer names and I still can't get them to fit. Is there a way to adjust the size or position of the dimension labels?

Thanks,

Shannon

Bar chart question

Wed, 08 Dec 2010 20:44:15 GMT

Also, does anyone know if it is possible to force the sort order of dimensions displayed in a bar chart? I need to set the order to

Wires Online

Wires Offline

Advances Online

Advances Offline

SK Online

SK Offline...etc.

Do I need to write an expression in sort tab?

Bar chart question

john_duffy — Wed, 08 Dec 2010 21:44:07 GMT

Hello.

What I usually do when I have long dimensions is changed the bar chart orientation to horizontal in the Style tab. This allows for long labels. Of course, the user has to be okay with this style.

As for the sort question, if I understand correctly, you want to sort the chart by specific dimensions. Not by their values, alphabetically, etc.

If so, one idea is to create a 'sort' table to be used in a sort expression. I have attached a small sample application. Let me know if this helps.

John.

Bar chart question

Wed, 08 Dec 2010 22:17:19 GMT

Great top on changing the orientation - thanks. I'll take a look at your attachment. Thanks for the help.