Discussion board where members can get started with QlikView.
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
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
Go to Solution.
SET MoneyFormat='€ #.##0,00;€ #.##0,00-';
SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';
@2 as name,
num(num#(@5)) as meas,
num(num#(@6)) as mean,
num(num#(@7)) as lower,
num(num#(@8)) as upper,
"C:\Documents and Settings\a.lam\Desktop\temp\A000*"
(txt, codepage is 1252, no labels, delimiter is '|', msq);
Its very simple. Go to the Settings -> Document Properties -> Number Tab-> Click on the field which have Exponential value and then click on Number.
That does not work for this format:
I need to read in these as number, can someone help me?
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;
Sorry, im a complete qlikview noob, can you modify this for me sow it reads in the exponetioal values: (meas, mean, lower, upper)
@5 as meas,
@6 as mean,
@7 as lower,
@8 as upper,
Thank you for your help, but.. now the values are gone, it shows "-" in my table object.
Can you send me the txt file.
Hello, thanks again for your efford!. The file is attached.
Its working my side.