topic Return Caracter in QlikView

Return Caracter

Thu, 14 Oct 2010 11:41:06 GMT

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

Thanks

Return Caracter

Thu, 14 Oct 2010 11:52:54 GMT

Hi,

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


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

Regards

Return Caracter

Miguel_Angel_Baeyens — Thu, 14 Oct 2010 12:01:54 GMT

Hi,

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

chr(10) & chr(13)

Regards.

Return Caracter

Thu, 14 Oct 2010 12:13:47 GMT

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

Return Caracter

Miguel_Angel_Baeyens — Thu, 14 Oct 2010 12:31:00 GMT

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.

Return Caracter

oscar_ortiz — Thu, 14 Oct 2010 15:17:27 GMT

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

Re. :Re: Return Caracter

Thu, 14 Oct 2010 18:06:53 GMT

Thank you OSCAR

Re. :Re: Return Caracter

oscar_ortiz — Thu, 14 Oct 2010 19:42:07 GMT

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

Re. :Re: Re. :Re: Return Caracter

Fri, 15 Oct 2010 09:19:26 GMT

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

Re. :Re: Re. :Re: Return Caracter

Fri, 15 Oct 2010 09:31:51 GMT

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

Re. :Re: Re. :Re: Re. :Re: Return Caracter

Fri, 15 Oct 2010 09:46:59 GMT

I like it appears unchanged. I use this string in the label of an expression in a PivotTable

thanks

Re. :Re: Re. :Re: Re. :Re: Return Caracter

Fri, 15 Oct 2010 09:54:46 GMT

Maybe your Nom_Colonne has two or more values. If a field has more than one value and use it in a label the field wll display blank.

if you want to test this you can use this code:


= Concat(Nom_Colonne, ',') & chr(10) & chr(13) & concat(A, ',')

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Return Caracter

Fri, 15 Oct 2010 10:06:46 GMT

Thank you, but I would like on the second line, the letter 'A' is centered.

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Return Caracter

Fri, 15 Oct 2010 10:16:48 GMT

You can changed the alignment of labels in presentation tab:

Re. :Re: Return Caracter

Thu, 06 Oct 2011 19:48:28 GMT

Why not use: & '\n' &

Won't that work in more Browsers.

Re: Return Caracter

gballester — Tue, 22 May 2018 13:01:43 GMT

Hi Miguel, thank you for your post.

I could not find a way to achieve a line break until I saw his post.

Guillermo