newline in expression

[alerse]

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>

[paul8pharma]

chr(10) worked for me.

[QlikKurt2]

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?

[BrunPierre]

@QlikKurt2 Perhaps

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

[QlikKurt2]

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

[talebalmakrani]

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

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download