topic Re: rounding issue in QlikView

rounding issue

Fri, 31 May 2013 05:51:43 GMT

4.255, when round it , i become 4.25instead of 4.26.

i want it to be 4.26,which should be correct in my understanding

Re: rounding issue

thomas_skariah — Fri, 31 May 2013 06:04:49 GMT

Hi Max,

If the value is 4.255 then it would be 4.25 and if it is 4.256 then it would be 4.26.

Regards,

Tom

Re: rounding issue

Fri, 31 May 2013 06:31:59 GMT

what does it mean when decimal is 5 , it would be ignored?

Re: rounding issue

Fri, 31 May 2013 06:32:04 GMT

what does it mean when decimal is 5 , it would be ignored?

Re: rounding issue

Sokkorn — Fri, 31 May 2013 06:32:37 GMT

Hi,

Here should work =Round(4.255,0.01) (reture 4.26)

Regards,

Sokkorn

Re: rounding issue

Fri, 31 May 2013 06:48:50 GMT

above method is not working

the overall score is caculated based on the teacherquality*0.8+ overallimpression*0.2

Re: rounding issue

tresB — Fri, 31 May 2013 06:51:41 GMT

yes, qv shows some weird(at least i can't explain it yet) results.

Look, first two are not as expected.

Re: rounding issue

Sokkorn — Fri, 31 May 2013 06:52:57 GMT

Did you set any Number format in Format tab?

Re: rounding issue

er_mohit — Fri, 31 May 2013 07:03:52 GMT

have you tried with ceil function

ceil(1.255,0.01)

Re: rounding issue

Fri, 31 May 2013 07:33:38 GMT

when fixed to is "3" it comes out 4.255, when fixed to"2" it is 4.25. but i want it to be 4.26 according my knowledge on round()

Re: rounding issue

Sokkorn — Fri, 31 May 2013 07:37:33 GMT

Hi,

Can you try to create Text Object and use this expression =Round(4.255,0.01) then give me the result. Just want to know it cause from your table or function.

Regards,

Sokkorn

Re: rounding issue

Fri, 31 May 2013 07:42:44 GMT

=Round(4.255,0.01) , it comes out 4.26

but

=round(4.655,0.01), it comes out 4.65

why?

Re: rounding issue

Sokkorn — Fri, 31 May 2013 08:04:01 GMT

Hi,

Can you try this one

=Ceil( 4.655 , 0.01 )

Rgds,

Sokkorn