Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

chr( n ) function

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.

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: chr( n ) function

3 Replies
Highlighted
Specialist II
Specialist II

Re: chr( n ) function

Highlighted
Master II
Master II

Re: chr( n ) function

Hi qlikviewnovice

Thank you so much. I got it now.

Highlighted
MVP & Luminary
MVP & Luminary

Re: chr( n ) function

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.