Discussion Board for collaboration on QlikView Scripting.
I am having data like given below column and this is looking like different format how do remove in qlikview Scripting?
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)
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 :
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