Qlik Community

QlikView Documents

Documents for QlikView related information.

Conversion of Exponential Notation to Decimal numbers

MVP
MVP

Conversion of Exponential Notation to Decimal numbers

Hi All,

The below script helps in converting the Exponential Notation (or Scientific Notation) numbers to Decimal numbers

Data:

LOAD ENumber,

     Num(ENumber, '(dec)') AS Decimal

INLINE [

ENumber

1.2600000000000000E-02

1.2700000000000000E+02

1.2800000000000000E+02

1.2900000000000000E+02

1.3000000000000000E+02

1.3100000000000000E+02

1.3200000000000000E+02

1.3300000000000000E+02

1.3400000000000000E+02

1.3500000000000000E+02

1.3600000000000000E+02

1.3700000000000000E+02

1.3800000000000000E+02

1.3900000000000000E+02

1.4000000000000000E+02

1.4100000000000000E+02

1.4200000000000000E+02];

Output:

ENumber Decimal
1.2600000000000000E-020.0125999999
1.2700000000000000E+02127
1.2800000000000000E+02128
1.2900000000000000E+02129
1.3000000000000000E+02130
1.3100000000000000E+02131
1.3200000000000000E+02132
1.3300000000000000E+02133
1.3400000000000000E+02134
1.3500000000000000E+02135
1.3600000000000000E+02136
1.3700000000000000E+02137
1.3800000000000000E+02138
1.3900000000000000E+02139
1.4000000000000000E+02140
1.4100000000000000E+02141
1.4200000000000000E+02142

Hope this helps you.

Regards,

jagan.

Comments

Useful information... TFS Jagan...!

psankepalli
Contributor III

Thanks Jagan.. is very informative..

Not applicable

Hello Jagan, Thanks for the doc. But how do we represent negative exponent with only 2 decimals? for eg, in the above example, how do we show '1.2600000000000000E-02' as only '0.012'?. Thanks.

Version history
Revision #:
1 of 1
Last update:
‎01-20-2016 03:09 AM
Updated by: