topic Re: inserting a line break in table box in QlikView

inserting a line break in table box

diwaskarki — Mon, 30 Apr 2018 21:25:11 GMT

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.

Re: inserting a line break in table box

el_aprendiz111 — Mon, 30 Apr 2018 22:47:39 GMT

Hi,

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

Re: inserting a line break in table box

diwaskarki — Tue, 01 May 2018 15:43:51 GMT

hello Jairo,

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

Re: inserting a line break in table box

vishsaggi — Tue, 01 May 2018 15:48:15 GMT

May be use Subfield() Function like

LOAD yourfieldlist,

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

FROM yoursource;

Then use this NewColName in your table box.

Re: inserting a line break in table box

sasiparupudi1 — Tue, 01 May 2018 16:03:03 GMT

Try

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

Re: inserting a line break in table box

bhaskar_sm — Thu, 03 May 2018 16:55:26 GMT

Hi,

Please find attached the Solution Qvw.

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

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

Regards,

Bhasker