Divide text in multiple lines

[EugeniaCastillaFragoso]

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? 

[mato32188]

Hi  @EugeniaCastillaFragoso,

perhaps this could help you

BR

m

[EugeniaCastillaFragoso]

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 😞 

[tresesco]

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
]

[mato32188]

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))

m

[EugeniaCastillaFragoso]

Hello @tresesco , 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

[rwunderlich]

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

-Rob