topic Using single quotes around a $-expansion containing chr(39) in QlikView https://community.qlik.com/t5/QlikView/Using-single-quotes-around-a-expansion-containing-chr-39/m-p/310366#M709093 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I've picked up this problem moving from QV9 to QV10. The handling of single quotes seems to be borken? I hope I can make this clear....</P><P></P><P>Given the following variables:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SET vVAL1 = Bob;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; LET vPARM1 = 'PARM1 = ' &amp; chr(39) &amp; vVAL1 &amp; chr(39);</P><P></P><P>Why does <STRONG>TRACE $(vPARM1); </STRONG>produce this output: <STRONG>PARM1 = 'Bob'</STRONG> (<EM>as one would expect</EM>)</P><P>while&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TRACE '$(vPARM1)';</STRONG> produces&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>'PARM1 = <SPAN style="color: #ff0000;">''</SPAN>Bob<SPAN style="color: #ff0000;">''</SPAN>'</STRONG> (<EM>notice the doubling of the single-quotes around Bob</EM>)</P><P></P><P></P><P>Thanks, </P><P>Brian </P></BODY></HTML> Tue, 30 Aug 2011 14:06:40 GMT 2011-08-30T14:06:40Z Using single quotes around a $-expansion containing chr(39) https://community.qlik.com/t5/QlikView/Using-single-quotes-around-a-expansion-containing-chr-39/m-p/310366#M709093 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I've picked up this problem moving from QV9 to QV10. The handling of single quotes seems to be borken? I hope I can make this clear....</P><P></P><P>Given the following variables:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SET vVAL1 = Bob;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; LET vPARM1 = 'PARM1 = ' &amp; chr(39) &amp; vVAL1 &amp; chr(39);</P><P></P><P>Why does <STRONG>TRACE $(vPARM1); </STRONG>produce this output: <STRONG>PARM1 = 'Bob'</STRONG> (<EM>as one would expect</EM>)</P><P>while&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TRACE '$(vPARM1)';</STRONG> produces&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>'PARM1 = <SPAN style="color: #ff0000;">''</SPAN>Bob<SPAN style="color: #ff0000;">''</SPAN>'</STRONG> (<EM>notice the doubling of the single-quotes around Bob</EM>)</P><P></P><P></P><P>Thanks, </P><P>Brian </P></BODY></HTML> Tue, 30 Aug 2011 14:06:40 GMT https://community.qlik.com/t5/QlikView/Using-single-quotes-around-a-expansion-containing-chr-39/m-p/310366#M709093 2011-08-30T14:06:40Z Using single quotes around a $-expansion containing chr(39) https://community.qlik.com/t5/QlikView/Using-single-quotes-around-a-expansion-containing-chr-39/m-p/310367#M709094 <HTML><HEAD></HEAD><BODY><P> bump</P></BODY></HTML> Wed, 31 Aug 2011 19:25:05 GMT https://community.qlik.com/t5/QlikView/Using-single-quotes-around-a-expansion-containing-chr-39/m-p/310367#M709094 2011-08-31T19:25:05Z