topic How to split Dimension Label in to two lines in barchart in Qliksense in App Development

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

indra — Fri, 01 Mar 2024 08:03:10 GMT

Hi Team,

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

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

LRuCelver — Fri, 01 Mar 2024 08:25:37 GMT

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)

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

indra — Fri, 01 Mar 2024 08:33:37 GMT

Hi,

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

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

anat — Fri, 01 Mar 2024 08:43:34 GMT

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

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

indra — Fri, 01 Mar 2024 09:01:51 GMT

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.

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

anat — Fri, 01 Mar 2024 12:37:38 GMT

You try below link script

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