topic Is round function inconsistent? in QlikView

Is round function inconsistent?

Tue, 19 Mar 2013 22:48:59 GMT

Attached is straight table that includes expressions for round function. Seems inconsistent.

=round(1.2) = 1

= round(1.5) = 2

= round(1.8) = 2

=round(1.2,1,.2) = 1.2

=round(1.3,1,.2) = 1.2

=round(1.4,1,.2) = 1.2

=round(1.5,1,.2) = 1.2 ??? why not 2.2

=round(1.6,1,.2) = 1.2 ??? why not 2.2

=round(1.7,1,.2) = 2.2

=round(1.8,1,.2) = 2.2

=round(1.9,1,.2) = 2.2

=round(1.99,1,.2) = 2.2

Attached is .qvw. This is likely very simple, just want to make sure I have the function straight.

Thanks,

Re: Is round function inconsistent?

CELAMBARASAN — Tue, 19 Mar 2013 23:17:42 GMT

It is working correcly.

Logic is it sets the base as 0.2,1.2, 2.2..... instead of 0,1,2

Ex:

for the case 0,1,2

0.4 is rounds to 0

0.5 is to 1

1.4 is to 1

1.7 is to 2

like the way for the case 0.2,1.2, 2.2

0.6 is to 0.2

0.7 is to 1.2 (means 0.2 + 0.5 round of starts)

1.4 to 1.2

1.8 to 2.2

Hope it helps

Celambarasan

Re: Is round function inconsistent?

Gabriel — Tue, 19 Mar 2013 23:20:36 GMT

Hi,

Chnage your .2 to 0.2 e.t.c

=round(1.2)

= round(1.5)

= round(1.8)

=round(1.2,1,0.2)

=round(1.3,1,0.2)

=round(1.4,1,0.2)

=round(1.5,1,0.2)

=round(1.6,1,0.2)

=round(1.7,1,0.2)

=round(1.8,1,0.2)

=round(1.9,1,0.2)

=round(1.99,1,0.2)

Regards,

Gabriel

Re: Is round function inconsistent?

Wed, 20 Mar 2013 01:28:10 GMT

Gabrriel,

This made no difference.

Thanks,

Donald Schafer

dj.schafer@comcast.net

978-582-1523

Re: Is round function inconsistent?

Wed, 20 Mar 2013 01:46:04 GMT

Ah, thanks, works for the cases but a little odd.

round(1.7, 1, .2) = 2.2

round(1.4, 1, .2) = 1.2

// set the new range base for round to the ones digit with offset of .2

// so it goes .2, 1.2, 2.2, 3.2, etc.. instead of 0, 1, 2, 3 etc... as the base ranges

// the middle number in this case is .7, 1.7, 2.7, 3.7, etc...

// So round of anything from .2<=x<.7 rounds down

// So round of anthing from .7<=x<1.2 rounds up

Kind of strange but this looks likely, thanks....

Re: Is round function inconsistent?

Wed, 20 Mar 2013 09:35:38 GMT

round(1.5,1,.2) means step is 1,offset is 0.2, available numerical are:

0.2 1.2 2.2

1.5 closer to 1.2