topic Re: Wrapping Y-axis dimension text in Horizontal bar chart in QlikView

Wrapping Y-axis dimension text in Horizontal bar chart

Tue, 27 Sep 2016 13:40:17 GMT

Hi Qlik Folks,

I have come across Y-axis dimensions with long names (with 60-70 character length) in Horizontal bar chart. Now I want to make the dimension as 3 liner as the name is not clearly visible.

We do not want to increase chart layout as it is fixed across all other charts.

I found some solutions to this kind of issue but all are leading to Vertical or diagonal bar chart.

Is it possible to have dimension values as wrapped text?

How to wrap text of a dimension used in bar chart??

https://community.qlikview.com/thread/125007

As the workaround , I had changed similar Horizontal bar chart to vertical and later tried to change it to Horizontal (original format) but it is not showing as expected.

Is it a limitation in QlikView with wrapping text in Horizontal bar chart or Could you please suggest the solution for it as soon as possible as the expectation is to resolve the issue immediately.

Many thanks in Advance,

Laxman.

Re: Wrapping Y-axis dimension in Vertical bar chart

giakoum — Tue, 27 Sep 2016 13:43:29 GMT

What we usually do is having short descriptions on the chart axis and displaying the long description on mouse over using a text as popup expression

Re: Wrapping Y-axis dimension text in Horizontal bar chart

Tue, 27 Sep 2016 13:49:20 GMT

Thank you Ioannis.

May be you are right.

But the requirement is to show the entire text which ever possible way(can be 2 or 3 liner).

Could you please suggest any possibility.

Many thanks in advance,

Laxman.

Re: Wrapping Y-axis dimension in Vertical bar chart

florentina_doga — Tue, 27 Sep 2016 13:50:59 GMT

so try to write dimension like

left(dimension,10)&chr(13)&mid(dimension,11,len(dimension)-10)

Re: Wrapping Y-axis dimension text in Horizontal bar chart

giakoum — Tue, 27 Sep 2016 13:54:37 GMT

If you have a fixed set of values in the dimension, always sorted in the same order, you can maybe use text in chart to label the bars (hide axis and use Ctrl + shift to adjust chart elements size and position). Not a good choice, since whenever a new value is added to the dimension, you will need to manually add the text, and bars size adjusts automatically in QV depending on expression value, but anyway it is worth trying.

Re: Wrapping Y-axis dimension in Vertical bar chart

Tue, 27 Sep 2016 13:58:48 GMT

Thank you Florentina.

The above code is slicing the dimension to first 10 characters only.

But we want to show the entire text within the layout possibly in 2-3 liner.

Could you please suggest any possibility.

Many thanks in advance,

Laxman.

Re: Wrapping Y-axis dimension text in Horizontal bar chart

Anonymous — Tue, 27 Sep 2016 13:59:07 GMT

I may have a workaround

please look for the text of your Dimension

if it is all of this Format abcdef - xyz (means the sign - separates the text

you may use this calculated Dimension:

replace(yourdimension, '-', chr(13)

I made a short test, in my case I got each Dimension in two lines

maybe that's something for you too?

Re: Wrapping Y-axis dimension in Vertical bar chart

Tue, 27 Sep 2016 14:13:50 GMT

Thank you Rudolf.

But this is not working in my case.

My dimension name is like this US_CA_MGR1 - Jonathan CollingwoodJr

So probably in my case it is limited to First word before the space character.

Could you please suggest the workaround.

Many thanks in advance,

Laxman.

Re: Wrapping Y-axis dimension text in Horizontal bar chart

florentina_doga — Tue, 27 Sep 2016 14:22:27 GMT

=left(bb,floor(aa/3))&chr(13)&mid(bb,floor(aa/3)+1,floor(aa/3))&chr(13)&mid(bb,2*floor(aa/3)+1,floor(aa/3))

bb=dimension

aa=len(dimension)

Re: Wrapping Y-axis dimension text in Horizontal bar chart

florentina_doga — Tue, 27 Sep 2016 14:29:20 GMT

try this

=left(bb,floor(aa/3))&chr(13)&mid(bb,floor(aa/3)+1,floor(aa/3))&chr(13)&mid(bb,2*floor(aa/3)+1,floor(aa/3))

replace

bb=dimension

and

aa=len(dimension)

Re: Wrapping Y-axis dimension in Vertical bar chart

Anonymous — Tue, 27 Sep 2016 14:29:58 GMT

I made a test with a Dimension with more values and notice the same behaviour (you only seem to have only 5 values of your Dimension and there should be enough space for second line)

sizing the Chart or enable x-axis scrollbar helps in my case to Show the second line of dimension

can you post sample qvw so I may have a look?

Re: Wrapping Y-axis dimension text in Horizontal bar chart

Wed, 28 Sep 2016 06:42:02 GMT

Thank you Rudolf.

I have tried sizing the Chart as well as enabling x-axis scrollbar. But it did not work for me.

I see the same issue i.e.

For dimension name US_CA_MGR1 - Jonathan CollingwoodJr

In QlikView, it is limited to First word before the space character.

And I am using QlikView 64 bit version 11.20 SR10.

Could you please give yours so that we can try out.

Thanks,

Laxman.