topic Re: Expression error in QlikView https://community.qlik.com/t5/QlikView/Expression-error/m-p/726114#M260408 <HTML><HEAD></HEAD><BODY><P>Hi Anbu,</P><P></P><P>Thanks for reply. How can make only 2 decimals and '%' after value?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 30 Sep 2014 10:21:46 GMT 2014-09-30T10:21:46Z Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726107#M260401 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am performing simple calculation, not sure why it is giving expression error. Please refer to the attached QVW and suggest.</P></BODY></HTML> Tue, 30 Sep 2014 10:01:35 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726107#M260401 2014-09-30T10:01:35Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726108#M260402 <HTML><HEAD></HEAD><BODY><P>Two issues at first glance:</P><UL><LI>field names should be in capitals (F1,.... <SPAN style="text-decoration: line-through;">f1</SPAN>.....)</LI><LI>Use Rangesum() instead of Sum()</LI></UL><P>Like,</P><P>=F2/Rangesum(F2+F3+F4) *100</P></BODY></HTML> Tue, 30 Sep 2014 10:08:38 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726108#M260402 tresB 2014-09-30T10:08:38Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726109#M260403 <HTML><HEAD></HEAD><BODY><P>Field names are case sensitive. Check this</P></BODY></HTML> Tue, 30 Sep 2014 10:10:23 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726109#M260403 anbu1984 2014-09-30T10:10:23Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726110#M260404 <HTML><HEAD></HEAD><BODY><P>Field name used is wrong its Starts with F. You can't directly use sum in dimension </P><P>Try,</P><P>F4/(F2+F3+F4)*100</P></BODY></HTML> Tue, 30 Sep 2014 10:12:42 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726110#M260404 sivarajs 2014-09-30T10:12:42Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726111#M260405 <HTML><HEAD></HEAD><BODY><P>Hi Tresesco,</P><P></P><P>Thanks for reply. How can make only 2 decimals and '%' after value?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 30 Sep 2014 10:12:46 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726111#M260405 2014-09-30T10:12:46Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726112#M260406 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P></P><P>=Num(F2/Rangesum(F2+F3+F4) *100,<STRONG>'#,##0.00%'</STRONG>)</P></BODY></HTML> Tue, 30 Sep 2014 10:18:08 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726112#M260406 tresB 2014-09-30T10:18:08Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726113#M260407 <HTML><HEAD></HEAD><BODY><P>It is showing Expression error.</P></BODY></HTML> Tue, 30 Sep 2014 10:21:19 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726113#M260407 2014-09-30T10:21:19Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726114#M260408 <HTML><HEAD></HEAD><BODY><P>Hi Anbu,</P><P></P><P>Thanks for reply. How can make only 2 decimals and '%' after value?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 30 Sep 2014 10:21:46 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726114#M260408 2014-09-30T10:21:46Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726115#M260409 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Instead of using the calculation in dimension, You can use the same in expression.</P><P>'=F2/RangeSum(F2+F3+F4) *100'</P><P></P><P>Then Go to Chart Properties---&gt;Number---&gt; Fixed to (2) decimals---&gt; Enable 'Show in Percent'</P><P></P><P></P><P>Regards,</P><P>Joshmi</P></BODY></HTML> Tue, 30 Sep 2014 10:21:55 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726115#M260409 2014-09-30T10:21:55Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726116#M260410 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am showing in the Dimension, not Expression. Hence I can't go to property and choose for these fields.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 30 Sep 2014 10:27:05 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726116#M260410 2014-09-30T10:27:05Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726117#M260411 <HTML><HEAD></HEAD><BODY><P>=Num(F2/(F2+F3+F4) *100,'####.##') &amp; '%'</P></BODY></HTML> Tue, 30 Sep 2014 10:27:16 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726117#M260411 anbu1984 2014-09-30T10:27:16Z Re: Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726118#M260412 <HTML><HEAD></HEAD><BODY><P>See attached qvw; first calculated dimension.</P></BODY></HTML> Tue, 30 Sep 2014 10:29:18 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726118#M260412 tresB 2014-09-30T10:29:18Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726119#M260413 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">Please try with the below code:[</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">=Num(F2/(F2+F3+F4) *100,'#0.##%') </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">Regards,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">Joshmi<BR /></SPAN></P></BODY></HTML> Tue, 30 Sep 2014 10:35:04 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726119#M260413 2014-09-30T10:35:04Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726120#M260414 <HTML><HEAD></HEAD><BODY><P>This works.</P><P></P><P> <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">=Num(F2/(F2+F3+F4) </SPAN> '#.00 %')</P><P></P><P>THnaks</P></BODY></HTML> Tue, 30 Sep 2014 11:28:42 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726120#M260414 2014-09-30T11:28:42Z Re: Expression error https://community.qlik.com/t5/QlikView/Expression-error/m-p/726121#M260415 <HTML><HEAD></HEAD><BODY><P>=num(F2/(F2+F3+F4),'#00.00%')</P></BODY></HTML> Tue, 30 Sep 2014 11:36:27 GMT https://community.qlik.com/t5/QlikView/Expression-error/m-p/726121#M260415 2014-09-30T11:36:27Z