topic Export value precision in QlikView https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730319#M1085247 <HTML><HEAD></HEAD><BODY><P><BR />Hi, can anyone please help me. I have just noticed that when i export my data into excel it sums up to a different total to my QlikView reports. The problem appears to be that the data in Qlikview is to 3 decimal places but when I export it into excel it rounds up to the nearest integer. Settings on both reports are set to money formatted to £ and no decimal places. Any idea how i resolve this as i can't see any settings to change other than the display format of money?</P></BODY></HTML> Mon, 23 Jun 2014 14:41:57 GMT 2014-06-23T14:41:57Z Export value precision https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730319#M1085247 <HTML><HEAD></HEAD><BODY><P><BR />Hi, can anyone please help me. I have just noticed that when i export my data into excel it sums up to a different total to my QlikView reports. The problem appears to be that the data in Qlikview is to 3 decimal places but when I export it into excel it rounds up to the nearest integer. Settings on both reports are set to money formatted to £ and no decimal places. Any idea how i resolve this as i can't see any settings to change other than the display format of money?</P></BODY></HTML> Mon, 23 Jun 2014 14:41:57 GMT https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730319#M1085247 2014-06-23T14:41:57Z Re: Export value precision https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730320#M1085248 <HTML><HEAD></HEAD><BODY><P>Did you ever figure this out? I'm facing the same issue. Cheers.</P></BODY></HTML> Thu, 24 Jul 2014 13:03:03 GMT https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730320#M1085248 richnorris 2014-07-24T13:03:03Z Re: Export value precision https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730321#M1085249 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You may try with below options specified in this post look at rob reply.</P><P><A _jive_internal="true" href="https://community.qlik.com/message/558608#558608">http://community.qlik.com/message/558608#558608</A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ASHFAQ</P></BODY></HTML> Thu, 24 Jul 2014 13:11:33 GMT https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730321#M1085249 ashfaq_haseeb 2014-07-24T13:11:33Z Re: Export value precision https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730322#M1085251 <HTML><HEAD></HEAD><BODY><P>Yep Richard, It was all around the formatting. Stupidly because I had formatted the cells to zero decimal places it exports at zero decimal places and then because you have lost the roundings then it gives you a different total. As such I changed the format to 5dp and it was fine. However, report looks stupid in QV now. Must be a quirk of the system. Frustrating</P></BODY></HTML> Thu, 24 Jul 2014 13:20:34 GMT https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730322#M1085251 2014-07-24T13:20:34Z Re: Export value precision https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730323#M1085252 <HTML><HEAD></HEAD><BODY><P>Thanks Ashfaq</P></BODY></HTML> Thu, 24 Jul 2014 13:24:02 GMT https://community.qlik.com/t5/QlikView/Export-value-precision/m-p/730323#M1085252 2014-07-24T13:24:02Z