Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Highlighted
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!

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