topic Re: X-axis wrap test in QlikView

X-axis wrap test

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have wrapped the text in x-axis by using the below code.But still i need the 'corpus christi and the valley' required more wrap.

Below is the image and code used to wrap the text.

Code:

=if(SubStringCount(trim(District_Desp),' ')<=6,

SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',1)

&' '&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',2)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',3)

&' '&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',4)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',5)

&' '&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',6)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',7))

Thanks..

sunny_talwar — Thu, 24 Nov 2016 13:13:59 GMT

May be this:

=if(SubStringCount(trim(District_Desp),' ')<=6,

SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',1)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',2)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',3)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',4)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',5)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',6)

&chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',7))

nareshthavidishetty — Fri, 25 Nov 2016 09:00:57 GMT

Hi Sunny,

Thanks a lot.

Pivot table column shift

sunny_talwar — Fri, 25 Nov 2016 12:04:35 GMT

Pivot table column shifts? Not sure what you mean?

nareshthavidishetty — Fri, 25 Nov 2016 16:32:52 GMT

please check in community it's an request.