topic Qlikview Decimal Value Anomaly in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Decimal-Value-Anomaly/m-p/1095914#M364064 <HTML><HEAD></HEAD><BODY><P>We have recently discovered an issue with loading numbers with decimal values.&nbsp; It appears that certain numbers when load into Qlikview are not stored as expected.&nbsp; an example is 64.01.&nbsp; This value when displayed will look ok until you override the format to Fixed to 14 decimals.&nbsp; At this point the number is 64.01000000000001.&nbsp; This anomaly is consistent&nbsp; and does not matter how the data is loaded, either inline, odbc, external flat file.&nbsp; Coping the data table to a text editor shows all of the values that have this anomaly but export does not as the data get cleaned up.&nbsp; Below is a screen shot of some of the data.&nbsp; Attached is Qlikview app that demonstrates the issue.&nbsp; Does anyone know why this is happening for any know issues that can attribute to this.</P><P></P><P><IMG alt="qlikview decimal anomaly.jpg" class="jive-image image-1" src="/legacyfs/online/117034_qlikview decimal anomaly.jpg" style="height: auto;" /></P><P>All numbers are load with just 2 decimal points.&nbsp; One set of numbers is load by using an autogenerate.&nbsp; The other using an inline load.&nbsp; Each has the same affect.&nbsp; Any thoughts would be appreciated.</P></BODY></HTML> Fri, 04 Mar 2016 20:43:27 GMT robert_young_hc 2016-03-04T20:43:27Z Qlikview Decimal Value Anomaly https://community.qlik.com/t5/QlikView/Qlikview-Decimal-Value-Anomaly/m-p/1095914#M364064 <HTML><HEAD></HEAD><BODY><P>We have recently discovered an issue with loading numbers with decimal values.&nbsp; It appears that certain numbers when load into Qlikview are not stored as expected.&nbsp; an example is 64.01.&nbsp; This value when displayed will look ok until you override the format to Fixed to 14 decimals.&nbsp; At this point the number is 64.01000000000001.&nbsp; This anomaly is consistent&nbsp; and does not matter how the data is loaded, either inline, odbc, external flat file.&nbsp; Coping the data table to a text editor shows all of the values that have this anomaly but export does not as the data get cleaned up.&nbsp; Below is a screen shot of some of the data.&nbsp; Attached is Qlikview app that demonstrates the issue.&nbsp; Does anyone know why this is happening for any know issues that can attribute to this.</P><P></P><P><IMG alt="qlikview decimal anomaly.jpg" class="jive-image image-1" src="/legacyfs/online/117034_qlikview decimal anomaly.jpg" style="height: auto;" /></P><P>All numbers are load with just 2 decimal points.&nbsp; One set of numbers is load by using an autogenerate.&nbsp; The other using an inline load.&nbsp; Each has the same affect.&nbsp; Any thoughts would be appreciated.</P></BODY></HTML> Fri, 04 Mar 2016 20:43:27 GMT https://community.qlik.com/t5/QlikView/Qlikview-Decimal-Value-Anomaly/m-p/1095914#M364064 robert_young_hc 2016-03-04T20:43:27Z Re: Qlikview Decimal Value Anomaly https://community.qlik.com/t5/QlikView/Qlikview-Decimal-Value-Anomaly/m-p/1095915#M364065 <HTML><HEAD></HEAD><BODY><P>I think this should explain most of your issue:</P><P><A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A></P></BODY></HTML> Fri, 04 Mar 2016 20:46:10 GMT https://community.qlik.com/t5/QlikView/Qlikview-Decimal-Value-Anomaly/m-p/1095915#M364065 swuehl 2016-03-04T20:46:10Z