topic Expression Label - Label on two lines in QlikView

Expression Label - Label on two lines

Anonymous — Fri, 08 Jun 2012 09:42:50 GMT

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!

Fri, 08 Jun 2012 09:49:26 GMT

Try with this expression:

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

A greeting.

Miguel_Angel_Baeyens — Fri, 08 Jun 2012 10:21:19 GMT

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 — Fri, 08 Jun 2012 10:52:01 GMT

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