topic Re: Converting scientific notation to numbers only [store] in QlikView https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449862#M1162354 <HTML><HEAD></HEAD><BODY><P>attached</P></BODY></HTML> Thu, 25 Oct 2012 15:42:48 GMT Anonymous 2012-10-25T15:42:48Z Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449856#M1162348 <HTML><HEAD></HEAD><BODY><P>Dear users,</P><P></P><P>I want to store a via join created qlikview table into a text document. Unfortunately, it stores the numbers (which are sometimes really "small") in scientific notation. For statistical purposes I need those in normal notation, but could not figure out how to until now. Any ideas?</P><P></P><P>Best regards</P><P>Stefan</P></BODY></HTML> Wed, 24 Oct 2012 18:00:25 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449856#M1162348 Anonymous 2012-10-24T18:00:25Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449857#M1162349 <HTML><HEAD></HEAD><BODY><P>Dear Stefan,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Please check my attachment ,can you conform you the that is your requirement.</P><P></P><P>SHAIK</P></BODY></HTML> Wed, 24 Oct 2012 18:43:13 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449857#M1162349 Anonymous 2012-10-24T18:43:13Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449858#M1162350 <HTML><HEAD></HEAD><BODY><P>Dear Shaik,</P><P></P><P>I'm not sure if I understand you correctly but these are "exactly" the figures I do not want to have. In your example scientific notation indicates high levels, my case is the opposite.&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 24 Oct 2012 22:13:16 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449858#M1162350 Anonymous 2012-10-24T22:13:16Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449859#M1162351 <HTML><HEAD></HEAD><BODY><P>Stefan,</P><P></P><P>what is the value range of your numbers? And how would you like it to be displayed? Would fixed number of decimal places would be ok, like</P><P></P><P>num(VALUE,'#,#####',',','.') as VALUE</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Wed, 24 Oct 2012 22:28:56 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449859#M1162351 swuehl 2012-10-24T22:28:56Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449860#M1162352 <HTML><HEAD></HEAD><BODY><P>Dear Stefan, </P><P></P><P>lowest value is: </P><TABLE border="0" cellpadding="0" cellspacing="0" width="174"><TBODY><TR><TD align="right" class="xl63" height="17" width="174">7,50639131350218E-18</TD></TR></TBODY></TABLE><P></P><P>it should be presented this way:</P><P>0,000000000000750639131350218</P><P></P><P>using the formatting argument in the num command produces an error. qlikview then does not export any value for the figures in scientific notation.</P><P></P><P>Best regards</P><P>Stefan</P></BODY></HTML> Thu, 25 Oct 2012 13:05:17 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449860#M1162352 Anonymous 2012-10-25T13:05:17Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449861#M1162353 <HTML><HEAD></HEAD><BODY><P>Dear Stefan,</P><P>&nbsp;&nbsp; Can you please provide your test data.</P><P></P><P>SHAIK</P></BODY></HTML> Thu, 25 Oct 2012 15:21:17 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449861#M1162353 Anonymous 2012-10-25T15:21:17Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449862#M1162354 <HTML><HEAD></HEAD><BODY><P>attached</P></BODY></HTML> Thu, 25 Oct 2012 15:42:48 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449862#M1162354 Anonymous 2012-10-25T15:42:48Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449863#M1162355 <HTML><HEAD></HEAD><BODY><P>ok, I solved that temporarily exporting the data from a table box into excel. It would nevertheless be interesing how to solve this problem in the script for larger data!</P></BODY></HTML> Fri, 26 Oct 2012 09:01:47 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449863#M1162355 Anonymous 2012-10-26T09:01:47Z Re: Converting scientific notation to numbers only [store] https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449864#M1162356 <HTML><HEAD></HEAD><BODY><P>Hi guys, this solved my problem.</P><P><A href="https://gist.github.com/ralfbecher/6550467" title="https://gist.github.com/ralfbecher/6550467">https://gist.github.com/ralfbecher/6550467</A></P></BODY></HTML> Wed, 30 May 2018 20:25:03 GMT https://community.qlik.com/t5/QlikView/Converting-scientific-notation-to-numbers-only-store/m-p/449864#M1162356 Anonymous 2018-05-30T20:25:03Z