Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamalqlik
Partner - Specialist
Partner - Specialist

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

12 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

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?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Can you send me the txt file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

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

Best Regards,

André Lam

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Its working my side.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!