topic Re: Apostrophe in valuelist in QlikView https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720901#M1055393 <HTML><HEAD></HEAD><BODY><P>Try valuelist('lil''wayne','lil''pop')</P></BODY></HTML> Tue, 14 Oct 2014 09:01:17 GMT Gysbert_Wassenaar 2014-10-14T09:01:17Z Apostrophe in valuelist https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720900#M1055392 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I would like to know if it's possible to use an apostrophe in a valuelist.</P><P>I mean I want to use something like this: valuelist('lil'wayne','lil'pop')</P><P>I tried to use the chr(39) function like this : valuelist('lil'&amp;chr(39)&amp;'wayne','lil'&amp;chr(39)&amp;'pop') but it doesn't work</P><P></P><P>Does anybody have an idea ?</P></BODY></HTML> Tue, 14 Oct 2014 08:38:36 GMT https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720900#M1055392 2014-10-14T08:38:36Z Re: Apostrophe in valuelist https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720901#M1055393 <HTML><HEAD></HEAD><BODY><P>Try valuelist('lil''wayne','lil''pop')</P></BODY></HTML> Tue, 14 Oct 2014 09:01:17 GMT https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720901#M1055393 Gysbert_Wassenaar 2014-10-14T09:01:17Z Re: Apostrophe in valuelist https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720902#M1055394 <HTML><HEAD></HEAD><BODY><P>CHR(96) will give you the grave accent (appears to the left of 1 on my UK keyboard)</P><P></P><P>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.</P></BODY></HTML> Tue, 14 Oct 2014 09:09:28 GMT https://community.qlik.com/t5/QlikView/Apostrophe-in-valuelist/m-p/720902#M1055394 flipside 2014-10-14T09:09:28Z