Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Conversion of Exponential Notation to Decimal numbers

cancel
Showing results for 
Search instead for 
Did you mean: 
jagan
Luminary Alumni
Luminary Alumni

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

Useful information... TFS Jagan...!

0 Likes
psankepalli
Partner - Creator III
Partner - Creator III

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
Last update:
Tuesday
Updated by:
Contributors