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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apostrophe in valuelist

Hi guys,

I would like to know if it's possible to use an apostrophe in a valuelist.

I mean I want to use something like this: valuelist('lil'wayne','lil'pop')

I tried to use the chr(39) function like this : valuelist('lil'&chr(39)&'wayne','lil'&chr(39)&'pop') but it doesn't work

Does anybody have an idea ?

Labels (1)
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try valuelist('lil''wayne','lil''pop')


talk is cheap, supply exceeds demand
flipside
Partner - Specialist II
Partner - Specialist II

CHR(96) will give you the grave accent (appears to the left of 1 on my UK keyboard)

EDIT: Or you can type the accent going the other way by holding down alt, typing 239 and letting go of alt. Chr(239) doesn't give the right char.