topic Re: Add Single Quotes to Text in QlikView https://community.qlik.com/t5/QlikView/Solved/m-p/1079011#M923452 <HTML><HEAD></HEAD><BODY><P>Using Chr(39) will work, just as Sunny suggests. A second possibility is to use an escape sequence in your Set or Let statement. See <A href="https://community.qlik.com/qlik-blogpost/4232">Escape sequences</A></P><P></P><P>HIC</P></BODY></HTML> Fri, 08 Apr 2016 07:59:06 GMT hic 2016-04-08T07:59:06Z Solved https://community.qlik.com/t5/QlikView/Solved/m-p/1079009#M923448 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1079009#M923448 microwin88x 2020-11-25T16:16:04Z Re: Add Single Quotes to Text https://community.qlik.com/t5/QlikView/Solved/m-p/1079010#M923450 <HTML><HEAD></HEAD><BODY><P>Use Chr(39) for single quote.</P><P></P><P>UPDATE: I guess you are using Concat function or GetFieldSelections may be?</P><P></P><P>Try this if its Concat:</P><P><STRONG>Concat(Chr(39) &amp; FieldName &amp; Chr(39), ',')</STRONG></P><P></P><P>or this if it is GetFieldSelections:</P><P><STRONG>Chr(39) &amp; GetFieldSelections(FieldName, Chr(39) &amp; ',' &amp; Chr(39), 1000000) &amp; Chr(39)</STRONG></P></BODY></HTML> Thu, 07 Apr 2016 19:58:15 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1079010#M923450 sunny_talwar 2016-04-07T19:58:15Z Re: Add Single Quotes to Text https://community.qlik.com/t5/QlikView/Solved/m-p/1079011#M923452 <HTML><HEAD></HEAD><BODY><P>Using Chr(39) will work, just as Sunny suggests. A second possibility is to use an escape sequence in your Set or Let statement. See <A href="https://community.qlik.com/qlik-blogpost/4232">Escape sequences</A></P><P></P><P>HIC</P></BODY></HTML> Fri, 08 Apr 2016 07:59:06 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1079011#M923452 hic 2016-04-08T07:59:06Z