topic Re: Wrap text in QlikView

Wrap text

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

Hi,

I need to show Corpus and The Valley in single line.Please find the below image.

Below is the code used to wrap the text.

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

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

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

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

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

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

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

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

&' '&SubField(replace(replace(replace(trim(Market),' -- ','-'),' - ','-'),' (','('),' ',8)

&chr(13)&SubField(replace(replace(replace(trim(Market),' -- ','-'),' - ','-'),' (','('),' ',9)

&' '&SubField(replace(replace(replace(trim(Market),' -- ','-'),' - ','-'),' (','('),' ',10)

&chr(13)&SubField(replace(replace(replace(trim(Market),' -- ','-'),' - ','-'),' (','('),' ',11))

Thankk..

Re: Wrap text

Anil_Babu_Samineni — Thu, 01 Dec 2016 15:45:47 GMT

Does this object is fixed, Or you may can increase the height to show single line for axis.

Re: Wrap text

thomaslg_wq — Thu, 01 Dec 2016 15:55:31 GMT

Is this already the case in the source value ?

If so : maybe you only want to replace the [return to line] by a [space].

So use this :

replace(Market,chr(10),' ')

Re: Wrap text

Chanty4u — Thu, 01 Dec 2016 15:58:02 GMT

try like below with your fields . its working for me in one project.

=left(Account, findoneof(Account, ' ', ceil(substringcount(Account, ' ')/2))) & chr(13) & chr(10) & right(Account, len(Account) - findoneof(Account, ' ', ceil(substringcount(Account, ' ')/2)))

Re: Wrap text

rubenmarin — Thu, 01 Dec 2016 16:26:12 GMT

Hi, your expression splits the strings by each ' ' it founds, and insert a chr(13) -new line- after each two ' ' it founds.

The bold-red text is causing the next line in that case:

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

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

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

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