topic chr( n ) function in QlikView

chr( n ) function

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I am just confused with using chr( n ) function. I have seen in help but didn't find full info.

Please help to provide sample application/information on this.

Thanks in advance.

Re: chr( n ) function

Anonymous — Sat, 29 Aug 2015 03:48:33 GMT

Hi,

Please have a look:

How to find a number for a char: chr() and ord() functions

Hope it will help!!

Re: chr( n ) function

qlikviewwizard — Sat, 29 Aug 2015 04:28:09 GMT

Hi qlikviewnovice

Thank you so much. I got it now.

Re: chr( n ) function

jagan — Sat, 29 Aug 2015 09:53:39 GMT

Hi,

Chr(AsciiNumber) will return the character of given ASCII number. Generally this is used when we want to insert single quote(') in our expression or in concatenation, since it is an error to mention single quote between ''.

Example:

If we want form a string like this - don't we need to use like below

='don' & Chr(39) & 't'

Or if you want to display Qlikview & Qliksense in two different lines in text object

='Qlikview' & Chr(10) & 'Qliksense' -- Ascii code for Carriage return is 10 --- Chr(10) = Enter key

output is:

Qlikview

Qliksense

Regards,

Jagan.