topic newline in expression in QlikView

newline in expression

alerse — Mon, 06 Jul 2009 15:56:57 GMT

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>

newline in expression

Mon, 06 Jul 2009 16:09:56 GMT

Hi,

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

- Sridhar

newline in expression

alerse — Mon, 06 Jul 2009 16:38:40 GMT

Perfect! Thanks!

newline in expression

Wed, 10 Mar 2010 16:49:04 GMT

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

newline in expression

Thu, 06 Oct 2011 20:12:59 GMT

How about:

& '\n' &

Re: newline in expression

brian554xx — Tue, 20 Sep 2016 14:47:43 GMT

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]))

Re: newline in expression

Thu, 08 Jun 2017 20:30:59 GMT

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.

Re: newline in expression

Anonymous — Thu, 25 Oct 2018 15:26:24 GMT

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

Re: newline in expression

brian554xx — Thu, 25 Oct 2018 16:36:48 GMT

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.

Re: newline in expression

akshay_goyal — Wed, 22 May 2019 09:38:10 GMT

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

Re: newline in expression

paul8pharma — Fri, 06 Aug 2021 08:41:15 GMT

chr(10) worked for me.

Re: newline in expression

QlikKurt2 — Tue, 23 Apr 2024 16:13:06 GMT

Can't make it work with the solutions posted:

=If (vActiveSheetName='VO', 'The VO sheet gives' & '\n' & 'This page'
neither does
=If (vActiveSheetName='VO', 'The VO sheet gives' & 'chr(10 or 13)' & 'This page'

Any suggestions?

Re: newline in expression

BrunPierre — Tue, 23 Apr 2024 16:36:49 GMT

@QlikKurt2 Perhaps

If(vActiveSheetName='VO', 'The VO sheet gives' & Chr(13) & 'This page')

Re: newline in expression

QlikKurt2 — Tue, 23 Apr 2024 19:00:42 GMT

Thanks, but doesn't seem to work with or without quotes. Tried clearing cache as well

Re: newline in expression

talebalmakrani — Thu, 13 Feb 2025 11:15:40 GMT

Hi All,
I attempted the same solution but was unable to achieve a new line. Below is my code :

if(Dimension3='abc', 'total Volume of abc'
& chr(13) & 'Source Systems :- Oracle' ,

if(Dimension3='def', 'total Volume of def'
& chr(13) & 'Source Systems :- Oracle',

if(Dimension3='ghi', 'total Volume of ghi'
& chr(13) & 'Source Systems :- Oracle'
)))