topic Re: Rounding problems in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519993#M552339 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!</P></BODY></HTML> Thu, 24 Oct 2013 10:43:16 GMT 2013-10-24T10:43:16Z Rounding problems in Qlikview https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519990#M552335 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an expression whic<SPAN style="font-size: 10pt; line-height: 1.5em;">h sums up parts, it could be for e.g. 0,4 parts or 0,6 parts. Does anyone know if it's possible to arrange in Qlikview that the parts are automatically rounded so that 0,4 parts = 0 and 0,6 parts = 1. In Qlikview now it is already rounded but when I export to excel the decimals shows. </SPAN></P><P></P><P>Thanks!</P><P>Sofie</P></BODY></HTML> Thu, 24 Oct 2013 10:33:40 GMT https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519990#M552335 2013-10-24T10:33:40Z Re: Rounding problems in Qlikview https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519991#M552337 <HTML><HEAD></HEAD><BODY><P>Try to add rounding to your expression, not using a number formatting rounding:</P><P></P><P>=round(sum(PARTS))</P></BODY></HTML> Thu, 24 Oct 2013 10:36:56 GMT https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519991#M552337 swuehl 2013-10-24T10:36:56Z Re: Rounding problems in Qlikview https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519992#M552338 <HTML><HEAD></HEAD><BODY><P>in expression use round() function<BR />round("Your expression")</P><P></P><P>Regards,</P><P>rajni</P></BODY></HTML> Thu, 24 Oct 2013 10:37:25 GMT https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519992#M552338 rajni_batra 2013-10-24T10:37:25Z Re: Rounding problems in Qlikview https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519993#M552339 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!</P></BODY></HTML> Thu, 24 Oct 2013 10:43:16 GMT https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519993#M552339 2013-10-24T10:43:16Z Re: Rounding problems in Qlikview https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519994#M552340 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!</P></BODY></HTML> Thu, 24 Oct 2013 10:43:23 GMT https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519994#M552340 2013-10-24T10:43:23Z Re: Rounding problems in Qlikview https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519995#M552341 <HTML><HEAD></HEAD><BODY><P>Are you using&nbsp; <SPAN style="color: #0000ff; font-size: 8pt;">Round</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Number</SPAN><SPAN style="font-size: 8pt;">,1)&nbsp; </SPAN><SPAN style="font-size: 8pt;">?</SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><BR /> </P></BODY></HTML> Thu, 24 Oct 2013 10:53:08 GMT https://community.qlik.com/t5/QlikView/Rounding-problems-in-Qlikview/m-p/519995#M552341 2013-10-24T10:53:08Z