Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Rounding Numeric value does not work

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.

5 Replies
sreenivas
Contributor III

Re: Rounding Numeric value does not work

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

khadeer_sparks
Valued Contributor

Re: Rounding Numeric value does not work

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

er_mohit
Honored Contributor II

Re: Rounding Numeric value does not work

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.

Not applicable

Re: Rounding Numeric value does not work

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.

er_mohit
Honored Contributor II

Re: Rounding Numeric value does not work

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.

Community Browser