topic Re: Value changes after 6 decimal points in QlikView https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429888#M430194 <HTML><HEAD></HEAD><BODY><P>May be assigning to decimals because DB. Can you post sample data how DB and Qlikview looks like?</P></BODY></HTML> Sat, 19 Aug 2017 16:16:31 GMT Anil_Babu_Samineni 2017-08-19T16:16:31Z Value changes after 6 decimal points https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429887#M430193 <HTML><HEAD></HEAD><BODY><P>We are loading data from one SQL query into qlikview application.</P><P></P><P>We are grouping it by Product and Client name. Lets say sum(revenue) by product in one table and by client in another.</P><P>Both tables are showing different Sum value post 6 decimal points it is same till 6 decimals.</P><P></P><P>Has anyone experienced this behavior? It is important for us in this case to get same values till 11-12 decimal points. Please guide.</P></BODY></HTML> Sat, 19 Aug 2017 16:06:57 GMT https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429887#M430193 rsdhavle 2017-08-19T16:06:57Z Re: Value changes after 6 decimal points https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429888#M430194 <HTML><HEAD></HEAD><BODY><P>May be assigning to decimals because DB. Can you post sample data how DB and Qlikview looks like?</P></BODY></HTML> Sat, 19 Aug 2017 16:16:31 GMT https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429888#M430194 Anil_Babu_Samineni 2017-08-19T16:16:31Z Re: Value changes after 6 decimal points https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429889#M430195 <HTML><HEAD></HEAD><BODY><P>How many decimal places do your numbers actually have?</P><P></P><P>Qlikview can only retain up to precision of 15 decimal places and may be rounding up the number to store it.</P><P></P><P><A href="http://documentation.qlikview.com/expressor/3.8/expressor_datascript_language/datascript_language_reference_guide/Values_and_Types.htm" title="http://documentation.qlikview.com/expressor/3.8/expressor_datascript_language/datascript_language_reference_guide/Values_and_Types.htm">Values and Types</A></P></BODY></HTML> Sat, 19 Aug 2017 16:31:27 GMT https://community.qlik.com/t5/QlikView/Value-changes-after-6-decimal-points/m-p/1429889#M430195 vinieme12 2017-08-19T16:31:27Z