wrap text x-axis in bar chart of qlikview

[#1]

Hi All,

I have Bar chart with with dimension(Customer) and Sales as Expression.

(Ex: In customer dim the values of customer as below on y-axis.How can we wrap the text in two columns for the same bar. (i.e 'people' in one row and 'government ' in another row) and the bar should be same.( EX:People

                                                                                                               Government 1,

                                                                                                                People

                                                                                                               Government 2 )

Customer	sales
People governament 1	10
People governament 2	20
People governament 3	30
People governament 4	40
People governament 5	40

[Anonymous]

Yes, but only if you use dimension axes like this: /

And, use calculated dimension like that:

left(Customer, 6) & chr(10) & mid(Customer, 😎

[MK_QSL]

Like this?

[#4]

Hi Michael,

I want to split it by word People is one word after that Space and Government in another word.what are the options in that case??

Split word by word or space by space

[Anonymous]

This exactly what I suggest.  Word 'People' is 6 characters long.

[#6]

Thanks Michael for the solution.But,the problem as per my design the orientation of bars are Horizantal and it showing people only in my graph the word 'Government' is cutting down.How to resolve this.Same problem in yours as well.

Please,find the attached document.How to resolve this problem?? document.

[#7]

use presentation tab - multiline settings (right bottom) - wrap cell text in two lines

and you will see all your second lines

[Anonymous]

Unfortunately my solution doesn't work for the horizontal style.  And, I can't see at this time what might work.

MRKachhiaIMP‌ uploaded a nice example.

(Although I don't see the reason to make the calculated dimension more complex than necessary.)

[#9]

Can you send me the Screenshot in which version of qlikview those options available in presentation Tab??

Mine is 11.20 SR10 64 bit.I can't see those options in mine.