Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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?
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
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);
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
Thank you for your help, but.. now the values are gone, it shows "-" in my table object.
HI,
Can you send me the txt file.
Regards,
Kaushik Solanki
Hello, thanks again for your efford!. The file is attached.
Best Regards,
André Lam
HI,
Its working my side.
Regards,
Kaushik Solanki