Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
diwaskarki
Creator II
Creator II

inserting a line break in table box

Hi,

I am displaying a string field in a table box.String is really long and is delimited by a '||'. I tried using a replace function to replace '||' with chr(10) which is a line break but this displays only one row in the table.

Is there an expression I can use to replace '||' with a line break? I would really appreciate it.  linebreak.png

1 Solution

Accepted Solutions
bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

Please find attached the Solution Qvw.

use the Chart Property-> Presentation-> check the Wrap Cell Text->enter 7

check.PNG

if you found this helpful, please mark as helpful or correct.

Regards,

Bhasker

View solution in original post

5 Replies
el_aprendiz111
Specialist
Specialist

Hi,

=replace('abecdfgg ||| asasdas || d dsfsdf|', '|', chr(13))

diwaskarki
Creator II
Creator II
Author

hello Jairo,

why do you have multiple '|||' and why do you have several string segments?

vishsaggi
Champion III
Champion III

May be use Subfield() Function like

LOAD yourfieldlist,

          Subfield([Removed Roles], '||') AS NewColName

FROM yoursource;

Then use this NewColName in your table box.

sasiparupudi1
Master III
Master III

Try

replace(YourField, '||', Chr(10)&chr(13))

bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

Please find attached the Solution Qvw.

use the Chart Property-> Presentation-> check the Wrap Cell Text->enter 7

check.PNG

if you found this helpful, please mark as helpful or correct.

Regards,

Bhasker