Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How did newline in Qlikview? In the legende of an expression for example.
Thanks
Hi,
Newline in Qlikview is Chr(13). Here's the sample code.
='Sample' & chr(13) & 'Code'
other sample:
=Concat(Month,chr(13))
Regards
Hi,
In some cases (textboxes), I've had to use
chr(10) & chr(13)
Regards.
Hi Miguel,
What's the difference between chr(10) and chr(13)?
In my example they produce the same output. Is there any specific use of these characters?
Thanks
Hello Nadsky,
It equals to CR/LF instead of doing just CR. I've come up with some objects where chr(13) (CR) is not enough (some ajax clients for example), and you need to use both to get something starting in a new line.
Regards.
Here's a little something that I put together just for those types of situations. Not sure which code to use? Look it up.
Hope this helps
Oscar
Thank you OSCAR
No problem, I find that I use this quite often when I need to purge certain characters from a client's dataset. Quite handy.
Please
I want to insert a new line in the name of an expression in a pivot table.
i have done this : Nom_Colonne & chr(10) & chr(13) & A. But it not worked.
it displays always the same string with chr(10) & chr(13).
Hi,
Is Nom_Colonne and A is a field name? try put an equal sign "=" before the code.
= Nom_Colonne & chr(10) & chr(13) & A