topic Re: Apostropohe in text in QlikView https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133121#M372300 <HTML><HEAD></HEAD><BODY><P>Ya unless you know about it, it is difficult to think that something like that would exist. Def. go through HIC's blog and you will learn many other interesting things about the escape sequence.</P></BODY></HTML> Thu, 12 May 2016 17:20:14 GMT sunny_talwar 2016-05-12T17:20:14Z Apostropohe in text https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133118#M372297 <HTML><HEAD></HEAD><BODY><P>I am trying to use a show conditional expression to show a text box when a particular channel is selected, however, the value defined in the dimension has an apostrophe in the text string.</P><P></P><P>If(Channel = 'Angie's List', True(), False()).</P><P></P><P>This causes an error in the expression due to the apostrophe in the name of the channel.&nbsp; </P><P></P><P>Thoughts?</P></BODY></HTML> Thu, 12 May 2016 13:40:50 GMT https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133118#M372297 2016-05-12T13:40:50Z Re: Apostropohe in text https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133119#M372298 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Try this:</SPAN></P><P></P><P><SPAN style="color: #3d3d3d; font-family: arial, helvetica, sans-serif; font-size: 10pt;"><STRONG>If(Channel = 'Angie<SPAN style="color: #ff0000; font-size: 14pt;">'</SPAN><SPAN style="color: #339966; font-size: 14pt;">'</SPAN>s List', True(), False()).</STRONG></SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Note, I used two single quotes and not a double quote above</SPAN></P><P><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;"><A href="https://community.qlik.com/qlik-blogpost/4232">Escape sequences</A></SPAN></P></BODY></HTML> Thu, 12 May 2016 16:59:05 GMT https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133119#M372298 sunny_talwar 2016-05-12T16:59:05Z Re: Apostropohe in text https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133120#M372299 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P><P></P><P>That was quick too!&nbsp; I tried all sorts of combinations, but didnt think to try two single quotes.</P></BODY></HTML> Thu, 12 May 2016 17:06:27 GMT https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133120#M372299 2016-05-12T17:06:27Z Re: Apostropohe in text https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133121#M372300 <HTML><HEAD></HEAD><BODY><P>Ya unless you know about it, it is difficult to think that something like that would exist. Def. go through HIC's blog and you will learn many other interesting things about the escape sequence.</P></BODY></HTML> Thu, 12 May 2016 17:20:14 GMT https://community.qlik.com/t5/QlikView/Apostropohe-in-text/m-p/1133121#M372300 sunny_talwar 2016-05-12T17:20:14Z