Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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