Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS

Conversion of Exponential Notation to Decimal numbers

MVP & Luminary
MVP & Luminary

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
MVP
MVP

Useful information... TFS Jagan...!

0 Likes
Partner
Partner

Thanks Jagan.. is very informative..

0 Likes
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.

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