# New to QlikView

Discussion board where members can get started with QlikView.

Valued Contributor

## How to convert an exponential no to decimal

Hi friends, I m facing a problem .Please suggest me the solution for the problem.

hey guys,how to convert an exponential number to decimal in

qlikview?

i tried mantissa*pow(10,exp) formula but mantissa that i

separate from the original field

,it is showing that it is neither a text nor a number.

Kamal Naithani

1 Solution

Accepted Solutions

## How to convert an exponential no to decimal

Hi,

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;€ #.##0,00-';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD-MM-YYYY';

SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

SET DayNames='ma;di;wo;do;vr;za;zo';

@2 as name,

@3,

@4,

num(num#(@5)) as meas,

num(num#(@6)) as mean,

num(num#(@7)) as lower,

num(num#(@8)) as upper,

@9,

@10,

@11,

@12,

@13,

@14,

@15,

@16,

@17,

@18,

@19

FROM

"C:\Documents and Settings\a.lam\Desktop\temp\A000*"

(txt, codepage is 1252, no labels, delimiter is '|', msq);

Regards,

Kaushik Solanki

12 Replies

## How to convert an exponential no to decimal

Hi,

Its very simple. Go to the Settings -> Document Properties -> Number  Tab-> Click on the field which have Exponential value and then click on Number.

Regards,

Kaushik Solanki

Not applicable

## How to convert an exponential no to decimal

That does not work for this format:

+1.961776E+03

+1.855197E+04

-1.304177E+07

-7.642861E+06

I need to read in these as number, can someone help me?

Highlighted

## How to convert an exponential no to decimal

HI,

Try this.

Data:
NUMBERS
+1.961776E+03
+1.855197E+04
-1.304177E+07
-7.642861E+06
];

Dat1:
Load Num(num#(NUMBERS)) as Num Resident Data;

Regards,

Kaushik Solanki

Not applicable

## How to convert an exponential no to decimal

Sorry, im a complete qlikview noob, can you modify this for me sow it reads in the exponetioal values: (meas, mean, lower, upper)

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;€ #.##0,00-';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD-MM-YYYY';

SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

SET DayNames='ma;di;wo;do;vr;za;zo';

@2 as name,

@3,

@4,

@5 as meas,

@6 as mean,

@7 as lower,

@8 as upper,

@9,

@10,

@11,

@12,

@13,

@14,

@15,

@16,

@17,

@18,

@19

FROM

"C:\Documents and Settings\a.lam\Desktop\temp\A000*"

(txt, codepage is 1252, no labels, delimiter is '|', msq);

## How to convert an exponential no to decimal

Hi,

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;€ #.##0,00-';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD-MM-YYYY';

SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

SET DayNames='ma;di;wo;do;vr;za;zo';

@2 as name,

@3,

@4,

num(num#(@5)) as meas,

num(num#(@6)) as mean,

num(num#(@7)) as lower,

num(num#(@8)) as upper,

@9,

@10,

@11,

@12,

@13,

@14,

@15,

@16,

@17,

@18,

@19

FROM

"C:\Documents and Settings\a.lam\Desktop\temp\A000*"

(txt, codepage is 1252, no labels, delimiter is '|', msq);

Regards,

Kaushik Solanki

Not applicable

## How to convert an exponential no to decimal

Thank you for your help, but.. now the values are gone, it shows "-" in my table object.

## How to convert an exponential no to decimal

HI,

Can you send me the txt file.

Regards,

Kaushik Solanki

Not applicable

## Re: How to convert an exponential no to decimal

Hello, thanks again for your efford!. The file is attached.

Best Regards,

André Lam

## How to convert an exponential no to decimal

HI,

Its working my side.

Regards,

Kaushik Solanki