topic Divide text in multiple lines in QlikView

Divide text in multiple lines

EugeniaCastillaFragoso — Thu, 13 May 2021 07:27:31 GMT

Hello!

I have the following issue, I have a dimmension that contains really long strings. A client has asked to divide that text in multiple lines, to read the information better.

Ex:

What I have: aaaaaaaaasssssssssdwwwddddddddddddddssssssssssssssssfewwwwwwwwwgriiiiiiiiijjjjjjjjjjjjjjjjjgrrrr

What I want:

aaaaaaaaaaaaaaaasss

sssdwwwdddddddddddddd

dssssssssssssssssfew

ssfewwwwwwwwwgriiiiiiiii

ijjjjjjjjjjjjjjjjjgrrrr

There is no separation parameter in the string.

does anyone have any suggestions as to how I may do this?

Re: Divide text in multiple lines

mato32188 — Thu, 13 May 2021 08:58:50 GMT

Hi @EugeniaCastillaFragoso,

perhaps this could help you

Re: Divide text in multiple lines

EugeniaCastillaFragoso — Thu, 13 May 2021 10:55:15 GMT

Hi @mato32188 , that unfortunately won't do it, as some text won't even fit like that, and plus, think this is a dynamic table, so sometimes that dimension is displayed and sometimes it isn't. So it is not the best thing to have super thick columns when that dimesnion isn't showing...
I don't know if you know of any loops to devide the text in let's say, 60 char or something like that 😞

Re: Divide text in multiple lines

tresB — Thu, 13 May 2021 11:28:23 GMT

Not sure if you are looking for something like below:

Let vLength=10; // set your value to 60 or so

Load
String,
Mid(String, $(vLength)*(IterNo()-1)+1,$(vLength)) as StringBroken
While len(String)>=$(vLength)*(IterNo()-1);

Load * Inline [
String
aaaaaaaaasssssssssdwwwddddddddddddddssssssssssssssssfewwwwwwwwwgriiiiiiiiijjjjjjjjjjjjjjjjjgrrrr
]

Re: Divide text in multiple lines

mato32188 — Thu, 13 May 2021 13:30:10 GMT

Hi @EugeniaCastillaFragoso ,

you can try to play a bit with chr(10) function that returns line feed, i.e.

mid(String,0,len(String)/2)&chr(10)&mid(String,len(String)/2,len(String))

Re: Divide text in multiple lines

EugeniaCastillaFragoso — Thu, 13 May 2021 13:49:28 GMT

Hello @tresB , thank you for your reply, unfortunately, this doesn't work for me. I want the text to still be one 'item' of the dimension 'String'.

What i want is to insert a chr(10) every each 60 char or so, so the text appears to be in many lines, not all in one

Re: Divide text in multiple lines

rwunderlich — Thu, 13 May 2021 20:40:18 GMT

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

-Rob