topic Re: Escape character for special character in Calculated Dimensions in QlikView https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735375#M263171 <HTML><HEAD></HEAD><BODY><P>No, there is none (yet). What do you want to do?</P><P></P><P>HIC</P></BODY></HTML> Tue, 08 Jul 2014 19:44:54 GMT hic 2014-07-08T19:44:54Z Escape character for special character in Calculated Dimensions https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735374#M263170 <HTML><HEAD></HEAD><BODY><P>Is there an escape character for special character in Calculated Dimensions (in Pivot Table), similar to \ for Python strings ?</P><P></P><P>I heard that I can use Chr(n) for special character in the script, but this is not working for calculated dimensions...</P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 08 Jul 2014 16:24:37 GMT https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735374#M263170 2014-07-08T16:24:37Z Re: Escape character for special character in Calculated Dimensions https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735375#M263171 <HTML><HEAD></HEAD><BODY><P>No, there is none (yet). What do you want to do?</P><P></P><P>HIC</P></BODY></HTML> Tue, 08 Jul 2014 19:44:54 GMT https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735375#M263171 hic 2014-07-08T19:44:54Z Re: Escape character for special character in Calculated Dimensions https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735376#M263172 <HTML><HEAD></HEAD><BODY><P>thanks for reply </P><P></P><P>I would like to have in a calculated dimension a pick(match('Val1', 'Val2'),'Rep1','Rep2') where 'Rep1' is a string including a single quote, for instance 'Game O'Game' </P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Jul 2014 07:03:15 GMT https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735376#M263172 2014-07-09T07:03:15Z Re: Escape character for special character in Calculated Dimensions https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735377#M263173 <HTML><HEAD></HEAD><BODY><P>Just write the single quote twice, and it should work. Like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;"> 'Game O''Game'</SPAN></P><P></P><P>HIC</P></BODY></HTML> Wed, 09 Jul 2014 07:28:32 GMT https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735377#M263173 hic 2014-07-09T07:28:32Z Re: Escape character for special character in Calculated Dimensions https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735378#M263174 <HTML><HEAD></HEAD><BODY><P>Thanks i will try so</P></BODY></HTML> Wed, 09 Jul 2014 07:51:22 GMT https://community.qlik.com/t5/QlikView/Escape-character-for-special-character-in-Calculated-Dimensions/m-p/735378#M263174 2014-07-09T07:51:22Z