Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Communiry,
I am having data like given below column and this is looking like different format how do remove in qlikview Scripting?
CODE
---------
7.00E+01
6.00E+02
6.00E+04
33286
533287
533296
541082
6.00E+08
6.00E+09
Regards,
Khasim.
Try num(evaluate(CODE))
Just the num() function should suffice. Some examples on your data you can check in a Text Box : :
num(7.00E+01)
num(533287)
num(6.00E+09)
or generic with your field: num(CODE)
Hi Gysbert,
Thanks for reply, I already tried with Num() not working giving same result and also used Num(Evaluate(CODE)),
still same result.
It works fine using this script with an inline load :
RawData :
LOAD * INLINE [
CODE
7.00E+01
6.00E+02
6.00E+04
33286
533287
533296
541082
6.00E+08
6.00E+09
];
load
num(CODE) as NumCode
resident RawData
;
Could you post an example that demonstrates your problem.
Hi,
Try Round(CODE, 0.01) AS NumCodeFormat
in the script