topic Error Syntax... in QlikView https://community.qlik.com/t5/QlikView/Error-Syntax/m-p/738199#M1058800 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>I am writing this expression:</P><P></P><P>=if((sum([Pre-Tax Value])/VTotalPreTaxValues)&gt;'02.00%', CustomerName)</P><P></P><P>I have to display only those Customer whose % value is greater than 2.00%, I am using above expression but it is not giving any customer name...</P><P></P><P>Please suggest....</P><P></P><P>Regards,</P><P>Balraj</P></BODY></HTML> Thu, 16 Oct 2014 11:07:17 GMT Anonymous 2014-10-16T11:07:17Z Error Syntax... https://community.qlik.com/t5/QlikView/Error-Syntax/m-p/738199#M1058800 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>I am writing this expression:</P><P></P><P>=if((sum([Pre-Tax Value])/VTotalPreTaxValues)&gt;'02.00%', CustomerName)</P><P></P><P>I have to display only those Customer whose % value is greater than 2.00%, I am using above expression but it is not giving any customer name...</P><P></P><P>Please suggest....</P><P></P><P>Regards,</P><P>Balraj</P></BODY></HTML> Thu, 16 Oct 2014 11:07:17 GMT https://community.qlik.com/t5/QlikView/Error-Syntax/m-p/738199#M1058800 Anonymous 2014-10-16T11:07:17Z Re: Error Syntax... https://community.qlik.com/t5/QlikView/Error-Syntax/m-p/738200#M1058801 <HTML><HEAD></HEAD><BODY><P>in your expression you are comparing the value of sum(pretax)/vtotal... with the string '02.00%' and i don't think they are saved like that in your schema right? the 2.00% is probably a number formatting in the chart that you are using, so check first what does this expression returns <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum([Pre-Tax Value])/VTotalPreTaxValues)</SPAN> and then add the filter.</P><P>maybe it should be <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum([Pre-Tax Value])/VTotalPreTaxValues)</SPAN> &gt; 0.2</P></BODY></HTML> Thu, 16 Oct 2014 11:10:03 GMT https://community.qlik.com/t5/QlikView/Error-Syntax/m-p/738200#M1058801 maleksafa 2014-10-16T11:10:03Z