Return Caracter

[#1]

How did newline in Qlikview? In the legende of an expression for example.

Thanks

[#2]

Hi,

Newline in Qlikview is Chr(13). Here's the sample code.

='Sample' & chr(13) & 'Code'
other sample:
=Concat(Month,chr(13))

Regards

[Miguel_Angel_Baeyens]

Hi,

In some cases (textboxes), I've had to use

chr(10) & chr(13)

Regards.

[#4]

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

[Miguel_Angel_Baeyens]

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.

[oscar_ortiz]

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

[#7]

Thank you OSCAR

[oscar_ortiz]

No problem, I find that I use this quite often when I need to purge certain characters from a client's dataset. Quite handy.

[#9]

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

[#10]

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