Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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>
chr(10) worked for me.
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?
@QlikKurt2 Perhaps
If(vActiveSheetName='VO', 'The VO sheet gives' & Chr(13) & 'This page')
Thanks, but doesn't seem to work with or without quotes. Tried clearing cache as well