Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression Label - Label on two lines

Hi,

I'm making a straight table & in that table, I would like to label my expressions.

I'm trying to get my label divided over 2 lines.

Code:

='Netweight '&(max(Year)-1)

This label would be:

Netweight 2011

I would like to make it this:

Netweight

2011

Does anyone know if this is possible?

Thanks!

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Following the idea by Daniel, this might work as well, if the Chr(10) alone does not:

='Netweight ' & Chr(10) & Chr(13) & (Max(Year)-1)

Hope that helps.

Miguel

View solution in original post

3 Replies
Not applicable
Author

Try with this expression:

='Netweight ' & chr(10) & (max(Year)-1)

A greeting.

Miguel_Angel_Baeyens

Hi,

Following the idea by Daniel, this might work as well, if the Chr(10) alone does not:

='Netweight ' & Chr(10) & Chr(13) & (Max(Year)-1)

Hope that helps.

Miguel

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

There is a simpler way. Click the edit expression button, and press enter inside the string, like this

='Netweight<enter>

' & (max(Year) - 1)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein