topic Re: Rounding Numeric value does not work in QlikView

Rounding Numeric value does not work

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Rounding Numeric value does not work

sreenivas — Wed, 19 Dec 2012 06:42:38 GMT

Num(Value,'###.##')

Re: Rounding Numeric value does not work

khadeer — Wed, 19 Dec 2012 06:43:43 GMT

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

Re: Rounding Numeric value does not work

er_mohit — Wed, 19 Dec 2012 06:56:29 GMT

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.

Re: Rounding Numeric value does not work

Wed, 19 Dec 2012 06:59:08 GMT

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.

Re: Rounding Numeric value does not work

er_mohit — Wed, 19 Dec 2012 11:08:26 GMT

hope it helps you.