How to split Dimension Label in to two lines in barchart in Qliksense

[indra]

Hi Team,

How to split Dimension Label in to two lines in barchart in Qliksense.

[LRuCelver]

You can use Chr(10) to add linebreaks to the text.

If you need it as a dimension, wrap it in an Aggr() over the original dimension so the filters are applied correctly.

Here is a small example that adds a linebreak after the 4th word. You can be creative in regards to where, how and how many linebreaks you want to add.

=Aggr(Left(LongLabel, FindOneOf(LongLabel, ' ', 4) - 1) & Chr(10) & Right(LongLabel, Len(LongLabel) - FindOneOf(LongLabel, ' ', 4)), LongLabel)

[indra]

Hi,

I used Chr(10), but not getting expected output. By using the above logic also not getting the expected result.

[anat]

Chr(10) will not work, you have to extend the object to view full text

[indra]

Hi, 

The label length is big. so we extended the object as much possible, but we are not able to extend object upto sheet ending, due to graph is not good to see users.

[anat]

You try below link script

https://community.qlik.com/t5/QlikView-App-Dev/Displaying-long-labels-on-chart-X-axis/td-p/358904