Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Let's just get to the point.
When I grabed numeric value from database to qlikview (e.g. 245.47),
qlikview didnt represent the numeric value as exactly 245.47, but instead 247.47000000029 (when i format it to 10 decimal places).
I am not sure why. how to get the data to show exactly 245.47 or 245.4700000000000.
i tried to use round function Round(value, 0.01) but i still have 247.47000000029.
Thanks.
Num(Value,'###.##')
If u want to display in chart, go to number tab and there u can find different options. else u can use num function in backend. hope it will help.
regards,
Khadeer
use expression :num(#,##0.00) or if you want to do it in pivot chart then in seeting of chart go to number tab there you fixed decimal value 2 and then u ll see on right side a pattern came... so, in which pattern you want to see check there
hope it helps you.
i used the function i the load script but i keep getting 247.47000000029 when I show the value in chart / list box.
I would it at least be 247.47000000000
Thanks.
use expression :num(#,##0.00) or if you want to do it in pivot chart then in seeting of chart go to number tab there you fixed decimal value 2 and then u ll see on right side a pattern came... so, in which pattern you want to see check there
hope it helps you.