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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.