Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

s_kunte23
Contributor III

Converting scientific notation to numbers only [store]

Dear users,

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?

Best regards

Stefan

8 Replies
shaik_basha
Contributor III

Re: Converting scientific notation to numbers only [store]

Dear Stefan,

     Please check my attachment ,can you conform you the that is your requirement.

SHAIK

s_kunte23
Contributor III

Re: Converting scientific notation to numbers only [store]

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.   

MVP
MVP

Re: Converting scientific notation to numbers only [store]

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

s_kunte23
Contributor III

Re: Converting scientific notation to numbers only [store]

Dear Stefan,

lowest value is:

7,50639131350218E-18

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

shaik_basha
Contributor III

Re: Converting scientific notation to numbers only [store]

Dear Stefan,

   Can you please provide your test data.

SHAIK

s_kunte23
Contributor III

Re: Converting scientific notation to numbers only [store]

attached

s_kunte23
Contributor III

Re: Converting scientific notation to numbers only [store]

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!

Highlighted
jigonzalez
New Contributor III

Re: Converting scientific notation to numbers only [store]

Hi guys, this solved my problem.

https://gist.github.com/ralfbecher/6550467

Community Browser