Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Line Break in Label

Hi experts,

For example I want to produce one output like this

Housekeeping

a)xxxxxxxxxxxxxxx

b)yyyyyyyyyyyyyyy

I tried to use Chr(10)

='Housekeeping' & Chr(10) & ' a) xxxxxxxxxxxxxx'   & Chr(10) & 'b) yyyyyyyyyyyyy'


but it did not work


Any ideas??


Thank you in advance!

1 Solution

Accepted Solutions
nsetty
Partner - Creator II
Partner - Creator II

Try this.


='Housekeeping' & Chr(10) & Chr(13) & ' a) xxxxxxxxxxxxxx'   & Chr(10)  & Chr(13) & 'b) yyyyyyyyyyyyy'

View solution in original post

6 Replies
nsetty
Partner - Creator II
Partner - Creator II

qlikstring.PNG

Above expression works perfectly with Chr(10).. I tried in text object

Anonymous
Not applicable
Author

Hi Nagesh,

Below is my input and output

input:

Qlik community 11.PNG

output :

Qlik community 11.1.PNG

Any ideas? Thank you!

nsetty
Partner - Creator II
Partner - Creator II

Try this.


='Housekeeping' & Chr(10) & Chr(13) & ' a) xxxxxxxxxxxxxx'   & Chr(10)  & Chr(13) & 'b) yyyyyyyyyyyyy'

Anonymous
Not applicable
Author

Hi Nagesh, if i mouse over the label, it looks like it worked. Thanks. i just need to find a way to increase the height of the label. thanks

Qlik community 11.2.PNG

Samrithi
Contributor III
Contributor III

Hi,

I am also facing the same Issue on adding line break on my KPI lable as it is long description.

="'Hi'&Chr(10)&Chr(13)&'Hello'"

Its not breaking line but its showing next line when I mouse hover.

clipboard_image_0.png

Appreciate the solution.

Thanks,

ZoharB
Contributor III
Contributor III

Ditto

It doesn't work in the visualization, only when you hover over with the mouse.

Any other suggestions?

Thanks