Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kamalqlik
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.

Thanks in advance

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';



LOAD @1,

     @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?

How to convert an exponential no to decimal

HI,

     Try this.

Data:
load * inline [
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';

LOAD @1,

     @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';



LOAD @1,

     @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

Highlighted
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.ScreenHunter_18.jpg

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

Community Browser