topic Need help in expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/462559#M172730 <HTML><HEAD></HEAD><BODY><P>Hello Friends</P><P></P><P>Need help in the expression, </P><P></P><P>Chart type is PIE chart and the Dimention is customer and the expression is to display the total amount and % of Amount, the expression is working fine.</P><P></P><P>but the amount is displaying the decimal point, I tryed to truncate it but failed not dispalying anything</P><P></P><P><STRONG>the expression as </STRONG></P><P><STRONG>dual( Num(sum( Amount),'# ##0') &amp; chr(10) &amp; num( sum([Amount])/sum(total [Amount]), '##%'), sum([ Amount]))</STRONG></P><P></P><P>Please help me,</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Mon, 28 Jan 2013 12:10:40 GMT 2013-01-28T12:10:40Z Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/462559#M172730 <HTML><HEAD></HEAD><BODY><P>Hello Friends</P><P></P><P>Need help in the expression, </P><P></P><P>Chart type is PIE chart and the Dimention is customer and the expression is to display the total amount and % of Amount, the expression is working fine.</P><P></P><P>but the amount is displaying the decimal point, I tryed to truncate it but failed not dispalying anything</P><P></P><P><STRONG>the expression as </STRONG></P><P><STRONG>dual( Num(sum( Amount),'# ##0') &amp; chr(10) &amp; num( sum([Amount])/sum(total [Amount]), '##%'), sum([ Amount]))</STRONG></P><P></P><P>Please help me,</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Mon, 28 Jan 2013 12:10:40 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/462559#M172730 2013-01-28T12:10:40Z Re: Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/462560#M172731 <HTML><HEAD></HEAD><BODY><P>Could you please post your example ?</P></BODY></HTML> Mon, 28 Jan 2013 12:30:52 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/462560#M172731 alexandros17 2013-01-28T12:30:52Z