Chr(10) CHR(13) <br>

[Rick_Sanchez_C137]

Hi everyone,

I'm a new QlikSense user, I used to work with PowerBI, Excel and I'm looking to transfer my work in QlikSense for reporting automation purposes.

I know it is a common question and frequently asked one but among 2h search I can't find the solution, each post gives the same answer that DOES NOT work or ISN'T solving the problem.

So here is  the question:

How to add a Chr(10)  or Chr(13)  in Table title ? Auto adjust is not suitable and often doesn't work or change with numbers in the column and it is very annnoying when it breaks between a date or a word.

1st answer found: use chr(10) or/and chr(13) -> doesn't work (weel it works when exporting data in excel but doesn't work in web interface of Qlik)

2nd answer found: It is impossible because html doesn't interprete chr(10).

3rd answer tried: try to use <br> -> doesn't work display <br> in plain text or failed formula title, maybe there is a solution to implement it.

4th answer found : It is not implemented in QlikSense and you shouldn't need it because of column adjustment: False I need it and the autoadjust won't detect line break at the right position, i'm sorry, and yes it is a pain for lisibility.

5th answer found: use text box -> How to add a text box in the table title ? As a new user i don't know how to add it in the title expression's formula.

Any help will be helpfull ! Thank you 🙂

[Lauri]

If you use it in the label of a table column, it will work. Like:

='Field' & Chr(10) & 'name'

It doesn't work for me in a table title.

I suspect the reference to a text box is for Qlik View, not Sense.

[Rick_Sanchez_C137]

Thanks for this view, do anyone know how to make it work in a table title ?

[DoctorPolidori]

Hi there!
I had a similar need to show a second line below the Title field on a chart and Ch(10) did not work but I managed to add a second line by using Subtitle.

[daturpin]

CHR(10) and CHR(13) just don't work in table titles. Neither does word wrap. You can use subtitles, or you can get creative with containers...  The developers of Qlik just didn't design this functionality.

[zhaofeng]

Unfortunately,Qlik Sense does not support wrap text by using chr(),blank space will be kept only one.

[DouglasFaustino]

Copie e cole esse espaço 'ㅤ'  e utilize  "&" para concatenar  com o seu texto, você pode adicionar esse espaço quantas vezes precisar.