I am having data like given below column and this is looking like different format how do remove in qlikview Scripting?
Thanks for reply, I already tried with Num() not working giving same result and also used Num(Evaluate(CODE)),
still same result.
Just the num() function should suffice. Some examples on your data you can check in a Text Box : :
or generic with your field: num(CODE)
It works fine using this script with an inline load :
LOAD * INLINE [
num(CODE) as NumCode
Could you post an example that demonstrates your problem.
Try Round(CODE, 0.01) AS NumCodeFormat
in the script
Retrieving data ...