
Re: Converting scientific notation to numbers only [store]
khadar basha Oct 24, 2012 2:43 PM (in response to Stefan Kunte)Dear Stefan,
Please check my attachment ,can you conform you the that is your requirement.
SHAIK

Re: Converting scientific notation to numbers only [store]
Stefan Kunte Oct 24, 2012 6:13 PM (in response to khadar basha)Dear Shaik,
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.

Re: Converting scientific notation to numbers only [store]
Stefan Wühl Oct 24, 2012 6:28 PM (in response to Stefan Kunte)Stefan,
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
num(VALUE,'#,#####',',','.') as VALUE
Regards,
Stefan

Re: Converting scientific notation to numbers only [store]
Stefan Kunte Oct 25, 2012 9:05 AM (in response to Stefan Wühl )Dear Stefan,
lowest value is:
7,50639131350218E18 it should be presented this way:
0,000000000000750639131350218
using the formatting argument in the num command produces an error. qlikview then does not export any value for the figures in scientific notation.
Best regards
Stefan




Re: Converting scientific notation to numbers only [store]
khadar basha Oct 25, 2012 11:21 AM (in response to Stefan Kunte)Dear Stefan,
Can you please provide your test data.
SHAIK

Re: Converting scientific notation to numbers only [store]
Stefan Kunte Oct 25, 2012 11:42 AM (in response to khadar basha)attached

test.qvw 150.8 K

Re: Converting scientific notation to numbers only [store]
Stefan Kunte Oct 26, 2012 5:01 AM (in response to Stefan Kunte)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!

