Solved: Re: Convert exponential to Value - Qlik Community - 1033081

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

Hi,

How to convert exponential value to number pls suggest.

Pls find the attached sample data.

1 Solution

Accepted Solutions

Hi,

Try like this

LOAD

Num(Replace(@1, ',', '.'), '(dec)') AS Formatted_Decimal

FROM

[exponential fig.xls]

(biff, no labels, table is Sheet1$);

Regards,

jagan.

View solution in original post

5 Replies

check the link

Convert Exponential values in Numbers??? | Qlik Community

chk dis

convert exponential number to decimal

Author

no luck

Hi,

Try like this

LOAD

Num(Replace(@1, ',', '.'), '(dec)') AS Formatted_Decimal

FROM

[exponential fig.xls]

(biff, no labels, table is Sheet1$);

Regards,

jagan.

The problem appears to be the , decimal. This works:

LOAD Num(Replace(@1, ',', '.')) As Value

FROM [exponential fig.xls]

(biff, no labels, table is Sheet1$);

EDIT: beaten to it by Jagan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein