topic Re: Wrap text of x axis dimension. in QlikView

Wrap text of x axis dimension.

Wed, 22 Jun 2011 13:34:00 GMT

Hi All,

I have a bar chart with one expression and one dimension. However the x axis labels for dimension values are too long and I want to wrap them in 2-3 lines. I tried various options in the Presentation, font and axes tabs but was unable to solve the problem. Is there some way I can solve this issue.

Thanks,

Neeraj

Re: Wrap text of x axis dimension.

Wed, 22 Jun 2011 14:14:51 GMT

Wraping up the Dimension value is not possible. But what you could do is, go to chart property --> Style and change the orientation to horizontal. Only this much you can do, not more than that

- Sridhar

Re: Wrap text of x axis dimension.

Wed, 22 Jun 2011 15:47:02 GMT

Thanks for the prompt reponse Sridhar !!

Regards,

Neeraj

Wrap text of x axis dimension.

Thu, 29 Sep 2011 09:14:17 GMT

Hi:

Inserting chr(13) after a specified length or specific number of words would result the x-axis labels to 2 lines.

Hope this helps!!

Narasimha K

Wrap text of x axis dimension.

Thu, 29 Sep 2011 19:22:48 GMT

Using a horizontal orientation is a good option. Or else if you need the same vertical plot, you can also try the following

Axes tab -> Change Primary dimension Labels to Vertical ( | ) or Inclined ( / )

Presentation Tab -> limiting the number of visible bars (Max Visible Number) and using X axis scroll bar

Not sure if you Dimension values are still bigger ..

Regards

Re: Wrap text of x axis dimension.

Thu, 09 Oct 2014 09:50:08 GMT

Qlikview: Wrapping text in X Axis

http://scribbledbygb.blogspot.co.uk/2014/10/wrap-text-in-x-axis-qlikview.html

Re: Wrap text of x axis dimension.

mohan2391 — Wed, 16 Dec 2015 05:54:01 GMT

Hi Narasimha,

Where to write that chr(13) ?

Could u pls give a clear explanation ?

Thank you

Re: Wrap text of x axis dimension.

sdmech81 — Thu, 19 Jan 2017 06:07:41 GMT

Hi,

What you can do is,if the dimension u are using is containing less number of values and if they are very long as you said above.

Then,you can use calculated dimensions and rename them or shorten them as you want..

let me know If anything needed..

Re: Wrap text of x axis dimension.

Anonymous — Thu, 09 Mar 2017 14:36:56 GMT

In the Presentation tab, unselect the Limit Legend (Characters) check box. This may help to display a few extra characters, but as mentioned by others - it is not possible to wrap text in legends

Re: Wrap text of x axis dimension.

Mon, 10 Apr 2017 03:18:25 GMT

Personally, I think this is a shortcoming of the application. I'm always being asked to "display the full labels"... which is a chore. It irks me to consider saying "no" to something as basic as that.

However, I've used something like the following as the expression of a dimension:

=if(Len([FieldName])>30,Left([FieldName],30) & '-' & Chr(10) & Right([FieldName],Len([FieldName])-30),[FieldName])

Essentially, this will look for field names > 30 characters.

If it's > 30, it splits the line @ the 30th character (using the Chr(10)) , adds a hyphen, and displays the remainder of the text on the line below. If it's < 30, it displays the whole field name.

Obviously you can change the number of characters from 30 to fit your own chart's size.

It's crude, but it works well enough in most instances.

If you come up with any better ideas, please let me know!

(I suspect there could be a way of counting the characters in a string, and counting the number of spaces in a string, then performing the split at one of those spaces so that you don't get single/orphan characters on the second line...but if the application just had a few more fundamental and improved display options, we wouldn't have to even consider it!)