topic Re: Convert exponential to Value in QlikView

Convert exponential to Value

abhaysingh — Wed, 20 Jan 2016 05:45:21 GMT

Hi,

How to convert exponential value to number pls suggest.

Pls find the attached sample data.

manojkulkarni — Wed, 20 Jan 2016 05:47:53 GMT

check the link

Chanty4u — Wed, 20 Jan 2016 05:49:31 GMT

chk dis

abhaysingh — Wed, 20 Jan 2016 06:49:45 GMT

no luck

jagan — Wed, 20 Jan 2016 07:39:38 GMT

Hi,

Try like this

LOAD

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

FROM

[exponential fig.xls]

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

Regards,

jagan.

jonathandienst — Wed, 20 Jan 2016 08:05:35 GMT

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