topic Re: if Statement in QlikView https://community.qlik.com/t5/QlikView/if-Statement/m-p/374177#M1168899 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try instead </P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13436455313311097" jivemacro_uid="_13436455313311097"><P>=If([GL_Hierarchy Short Description2] = 'Profit &amp; Loss A/C' &amp; Chr(39) &amp; 's', [GL_Hierarchy Short Description2])</P></PRE><P></P><P>The Chr(39) substitutes the ' character.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 30 Jul 2012 10:52:39 GMT Miguel_Angel_Baeyens 2012-07-30T10:52:39Z if Statement https://community.qlik.com/t5/QlikView/if-Statement/m-p/374176#M1168898 <HTML><HEAD></HEAD><BODY><P>=if([GL_Hierarchy Short Description2]='Profit &amp; Loss A/C's,[GL_Hierarchy Short Description2])</P><P></P><P>getting error on this point in above statement A/C<SPAN style="text-decoration: underline;">'<STRONG>s</STRONG></SPAN>, kindly help me to fix this out.</P><P>Regards.</P></BODY></HTML> Mon, 30 Jul 2012 10:47:36 GMT https://community.qlik.com/t5/QlikView/if-Statement/m-p/374176#M1168898 2012-07-30T10:47:36Z Re: if Statement https://community.qlik.com/t5/QlikView/if-Statement/m-p/374177#M1168899 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try instead </P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13436455313311097" jivemacro_uid="_13436455313311097"><P>=If([GL_Hierarchy Short Description2] = 'Profit &amp; Loss A/C' &amp; Chr(39) &amp; 's', [GL_Hierarchy Short Description2])</P></PRE><P></P><P>The Chr(39) substitutes the ' character.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 30 Jul 2012 10:52:39 GMT https://community.qlik.com/t5/QlikView/if-Statement/m-p/374177#M1168899 Miguel_Angel_Baeyens 2012-07-30T10:52:39Z Re: if Statement https://community.qlik.com/t5/QlikView/if-Statement/m-p/374178#M1168900 <HTML><HEAD></HEAD><BODY><P>thnxs Miguel</P></BODY></HTML> Mon, 30 Jul 2012 10:56:53 GMT https://community.qlik.com/t5/QlikView/if-Statement/m-p/374178#M1168900 2012-07-30T10:56:53Z