Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

newline in expression

Hi

I've tried everything but cant figure out how to insert a new line character... I would like to show these three fields below each other. nl doesn't work...


=Maxstring(If([L1] = VarL1Out and Isnull([L2]),[HoverText])) &'. Actual: '
&Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual])) & '. Target: '
&Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target]))
{/code]
Currently the help text looks like this:
My hovertext. Actual: 50.4. Target: 55.5
I want to be like:
My hovertext.
Actual: 50.4.
Target: 55.5</body>
1 Solution

Accepted Solutions
Highlighted
Not applicable

newline in expression

Hi,

Use chr(13) b/w the lines. This function will generate the new line.

- Sridhar

View solution in original post

9 Replies
Highlighted
Not applicable

newline in expression

Hi,

Use chr(13) b/w the lines. This function will generate the new line.

- Sridhar

View solution in original post

Highlighted
Contributor II
Contributor II

newline in expression

Perfect! Thanks!

Highlighted
Not applicable

newline in expression

It does not work on ClikView server with FireFox or Google Chrome...

Highlighted
Not applicable

newline in expression

How about:

&  '\n' &

Highlighted
Contributor III
Contributor III

Re: newline in expression

It usually works to include the newline in your string, like so:

=Maxstring(If([L1] = VarL1Out and Isnull([L2]),[HoverText])) & '. Actual:

' & Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual])) & '. Target:

' & Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target]))

Highlighted
Not applicable

Re: newline in expression

Hi,
That trick really helps, and its very simpler. Thanks for sharing!

I'm using Qlik Sense 3.2 SR2 and the chr(13) didn't worked for me, but breaking a literal new line inside the quotes did the trick. I tried that to break two complimentary information in two lines as a Bar Chart measure description.

Highlighted
Creator
Creator

Re: newline in expression

Can you please share the expression how you did it. Thank you.

Highlighted
Contributor III
Contributor III

Re: newline in expression

My expression is shown in my earlier post. If you're asking for Fernando's expression, I am certain it is similar.

If I misunderstand, please correct me.

Highlighted
Contributor
Contributor

Re: newline in expression

The expression posted in the problem statement and the solution looks exactly same. Can you please post the solution expression again?