Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use single quote as part of a string literal?

Hi,

I want to use a single quote as part of a string literal. Is the chr(39) function the only solution?

Example with chr(39) function:

LET vMyVar = 'hello ' & chr(39) & 'WORLD' & chr(39) & ' from panos!';

sets the value

hello 'WORLD' from panos

to vMyVar.

Is there something like an escape sequence that I can use?

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

Hi,

There is no escape sequences in qlikview, you have to use chr() for characters like '(Apostrophe).

Regards,

Jagan.

View solution in original post

1 Reply
jagan
Partner - Champion III
Partner - Champion III

Hi,

There is no escape sequences in qlikview, you have to use chr() for characters like '(Apostrophe).

Regards,

Jagan.