topic Use of Round function in QlikView

Use of Round function

Thu, 05 Sep 2013 13:33:20 GMT

hi,

Can anybody explain how does the Round function work?

please see the results i got below.

Round(3.88,0) = 1

Round(3.88,1) = 4

Round(3.88,2) = 4

Round(3.88,3) = 3

Round(3.88,4) = 4

Round(3.88,5) = 5

Round(3.88,6) = 6

Round(3.88,7) = 7

Round(3.88,8) = 0

Round(3.88,9) = 0

Round(3.88,10) = 0

Can you explain this?

Thanks

Re: Use of Round function

swuehl — Thu, 05 Sep 2013 13:41:32 GMT

Round to the closest multiple of your second argument (multiples are all integeres incl. zero), explains all of your results except first (multiple of zero doesn't makes sense, I assume result of 1 is a fixed logic).

Re: Use of Round function

Andrea_Ghirardello — Thu, 05 Sep 2013 13:56:55 GMT

In the QlikView help:

round (x [ , step [ , offset ]])

Rounding of x upwards or downwards n number of steps with an offset of offset. The result is a number. If x is exactly in the middle of an interval, it is rounded upwards. The function complies with the IEEE standard 64-bit floating point numbers.

Examples:

round( 2.4 ) returns 2

round( 2.6 ) returns 3

round( 2.5 ) returns 3

round( 3.88 , 0.1 ) returns 3.9

round( 3.88 , 5 ) returns 5

round( 1.1 , 1 , 0.5 ) returns 1.5