https://community.qlik.com/t5/App-Development/Numeric-values-not-the-same-after-application-being-reloaded/m-p/1891193#M73439 <P>Hi Guys</P> <P>I have encountered a weird scenario while developing one of my application.</P> <P>I have a field in oracle database called Amount having a data type as NUMBER(38,4)&nbsp; which contains below values</P> <TABLE style="border-collapse: collapse; width: 48pt;" border="0" width="64" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64" height="19" style="height: 14.5pt; width: 48pt;">Amount</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" align="right" class="xl63" style="height: 14.5pt;">0.0000</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" align="right" style="height: 14.5pt;">28.3487</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" align="right" style="height: 14.5pt;">36.5643</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Now , when I am loading the application from QMC , values are getting changed as below, however when I am loading data manually from QlikView desktop , values are showing as it is in the database (As shown above).</P> <TABLE style="border-collapse: collapse; width: 48pt;" border="0" width="65px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" style="height: 14.5pt; width: 48pt;">Amount</TD> </TR> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" align="right" class="xl63" style="height: 14.5pt;">0</TD> </TR> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" align="right" style="height: 14.5pt;">28.3487</TD> </TR> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" align="right" style="height: 14.5pt;">36.5643</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please help me understand this behavior of QlikView</P> <P>Many thanks in advance</P> Wed, 09 Feb 2022 18:43:12 GMT Manish 2022-02-09T18:43:12Z https://community.qlik.com/t5/App-Development/Numeric-values-not-the-same-after-application-being-reloaded/m-p/1891193#M73439 <P>Hi Guys</P> <P>I have encountered a weird scenario while developing one of my application.</P> <P>I have a field in oracle database called Amount having a data type as NUMBER(38,4)&nbsp; which contains below values</P> <TABLE style="border-collapse: collapse; width: 48pt;" border="0" width="64" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64" height="19" style="height: 14.5pt; width: 48pt;">Amount</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" align="right" class="xl63" style="height: 14.5pt;">0.0000</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" align="right" style="height: 14.5pt;">28.3487</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" align="right" style="height: 14.5pt;">36.5643</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Now , when I am loading the application from QMC , values are getting changed as below, however when I am loading data manually from QlikView desktop , values are showing as it is in the database (As shown above).</P> <TABLE style="border-collapse: collapse; width: 48pt;" border="0" width="65px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" style="height: 14.5pt; width: 48pt;">Amount</TD> </TR> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" align="right" class="xl63" style="height: 14.5pt;">0</TD> </TR> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" align="right" style="height: 14.5pt;">28.3487</TD> </TR> <TR style="height: 14.5pt;"> <TD width="64.5px" height="19" align="right" style="height: 14.5pt;">36.5643</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please help me understand this behavior of QlikView</P> <P>Many thanks in advance</P> Wed, 09 Feb 2022 18:43:12 GMT https://community.qlik.com/t5/App-Development/Numeric-values-not-the-same-after-application-being-reloaded/m-p/1891193#M73439 Manish 2022-02-09T18:43:12Z