topic Re: Line break in text box? in App Development

Line break in text box?

sjb34300 — Mon, 27 Jul 2015 16:31:17 GMT

I want to add a line break in a text box in Qlik Sense. Any ideas how to do that? The text box doesn't seem to respect html or ascii. It just shows that code as text.

Re: Line break in text box?

sunny_talwar — Mon, 27 Jul 2015 17:07:57 GMT

Try Chr(10) or Chr(13).

For instance:

Text & Chr(10) & Text or

Text & Chr(13) & Text

Re: Line break in text box?

sjb34300 — Mon, 27 Jul 2015 21:00:01 GMT

Thanks! That worked. And just to clarify for others, I had to add this in the expression of the measure. I couldn't just add the ascii to the text box with only text in it.

'Hourly Revenue: ' & HourlyRevenue & chr(10) & 'Fixed Fee Revenue: ' & FixedFeeRevenue

Re: Line break in text box?

carlcimino — Wed, 14 Mar 2018 14:27:04 GMT

I can't get this to work for a label on a qlik sense map. It still puts it side by side. I tried both chr(10) and chr(13). Any ideas?

=ZIP_CODE&chr(10)&

text(num(

(sum({<DateType={Create},YTD_FLAG={'Y'}>}QUOTED_PREMIUM)

/sum({<DateType={Create},PYTD_FLAG={'Y'}>}QUOTED_PREMIUM)

)-1,'#.#%'))

Re: Line break in text box?

tarunakhemchand — Mon, 26 Mar 2018 11:28:49 GMT

@carl Same for me!!

Re: Line break in text box?

robjackson_enta — Thu, 03 Jan 2019 10:40:35 GMT

Hi, you can try the following using but it has to be wrapped in single quotes..

='LabelText' & Field Name & ' ' & 'LabelText' & Field Name

Re: Line break in text box?

JohannesHiller — Thu, 03 Jan 2019 12:49:02 GMT

Perfect. Using and not chr(10) finaly made it work. Thanks.

Re: Line break in text box?

Vince_CH — Mon, 28 Jan 2019 07:16:10 GMT

Dear All, I tried with Chr(10), Chr(13) and ' ', all doesn't work in the footnotes where i want to break the lines. anyone has the successful experience there?

Re: Line break in text box?

EliGohar — Sun, 24 Feb 2019 15:09:46 GMT

tried all of the proposed solutions on Title, without success.

Re: Line break in text box?

qlikdelqbz — Mon, 25 Feb 2019 16:01:08 GMT

same for me. both and chr(13) do not work.

Re: Line break in text box?

mhoudas78 — Wed, 31 Jul 2019 09:03:39 GMT

Chr(10) or chr(13) don't work.

there is a limitation and the answear is not the reponsible design

Re: Line break in text box?

smgt90 — Fri, 12 Feb 2021 01:02:12 GMT

char(10) was what worked for me

Re: Line break in text box?

krzohi — Sun, 05 Dec 2021 16:11:23 GMT

For me also none of those proposals work..

This issue is from 2015 and now is almost 2022 for gods sake!!!

Qlik WAKE UP!!!!

Re: Line break in text box?

SrikarSiddarth — Mon, 26 Jun 2023 06:42:17 GMT

Hi,

For all users using Qlik on Windows, we need to add both \r\n (carriage return and newline characters) to obtain a new line.

source: .https://www.geeksforgeeks.org/whats-the-difference-between-n-and-rn-in-php/#:~:text=%5Cr%5Cn%20%3A,sequence%20because%20of%20backward%20compatibility.

Thus we need to add both chr(10) & chr(13) in the same order. For example:
='abc' & Chr(10) & Chr(13) & 'def'
source: https://community.qlik.com/t5/New-to-Qlik-Sense/Line-Break-in-Label/td-p/107737

Re: Line break in text box?

krzohi — Thu, 20 Jul 2023 07:12:32 GMT

Hi,

this solution doesn't wotk