topic Re: Prob regarding Floor ? in QlikView

Prob regarding Floor ?

nikhilgarg — Thu, 26 Feb 2015 09:54:19 GMT

Hey,

If we use floor(2.6), it will give the lower value i.e.2.0

But, i dont understand following result:

floor( 3.88 , 0.1 ) returns 3.8

floor( 3.88 , 5 ) returns 0

floor( 1.1 , 1 , 0.5 ) returns 0.5

Can anyone help ?

tHanks

Re: Prob regarding Floor ?

jagan — Thu, 26 Feb 2015 10:09:30 GMT

Hi,

floor( 3.88 , 0.1 ) returns 3.8 --- This rounds upto 0.1 so 3.88 becomes 3.8 (0.08 is rounded)

floor( 3.88 , 5 ) returns 0 --- This rounds upto 5, so 3.88 becomes 0 (since 3.88 is less than 5)

floor( 6.88 , 5 ) returns 5 --- Here we are rounding by multiples of 5

floor(10.22, 5) returns 5 --- Same as above

floor( 1.1 , 1 , 0.5 ) returns 0.5 - floor( 1.1 , 1) rounds to 1 and offset 0.5 will return 0.5

floor( 2.1 , 1 , 0.5 ) returns 0.5 - floor( 2.1 , 1) rounds to 2 and offset 0.5 will return 1.5

Hope it helps you.

Regards,

Jagan.

Re: Prob regarding Floor ?

nikhilgarg — Thu, 26 Feb 2015 10:17:35 GMT

Hey thanx, but i am confused about that:

floor( 3.88 , 0.1 ) , does this 0.1 indicates it will round to 1 decimal place after decimal.

floor( 6.88 , 5 ) , i dont understand what 5 means here, is it nmber of place or what?

THanks

Re: Prob regarding Floor ?

CELAMBARASAN — Thu, 26 Feb 2015 10:24:17 GMT

Range is 0 to 1

Floor(3.88) it will give you the result without any decimal points, which is equal to Floor(3.88, 1)

Range is 0 to 5

When it comes to Floor(3.88, 5) will give you 0, but Floor(6, 5) will give you 5
Assume 5 is the higher round off and 0 is lower one

Floor(3.88, 0.1) it will give you the result up to 1 decimal point

Re: Prob regarding Floor ?

Thu, 26 Feb 2015 10:34:54 GMT

floor(x [ , base [ , offset ]])

Rounding of x downwards to the nearest multiple of base with an offset of offset. The result is a number.

In your case x=3.88 base=0.1 offset is not mentioned

You should check for the largest multiple of 0.1(.....,3.5,3.6,3.7,3.8) which is less than 3.88, is 3.8

For suppose x=4.05 base=0.2 offset is not mentioned

The largest multiple of 0.2 (......,3.6,3.8,4.0) which is less than 4.05 is 4.0.

Similarly x=3.88, base=5,offset is not mentioned

largest multiple of 5 which is less than 3.88 is 0

when x=1.1,base=1,offset=0.5

we will do that in two steps,when x=1.1, base=1 and then solve for offset. The solution for this is 1

When we add offset in floor() this it is just flooring the answer in above case by offset value therefore it becomes 0.5

Re: Prob regarding Floor ?

Anonymous — Thu, 26 Feb 2015 11:01:27 GMT

Hi Nikhil,

Check this post Rounding-errors by henric.

Regards

Neetha

Re: Prob regarding Floor ?

nikhilgarg — Thu, 26 Feb 2015 11:10:01 GMT

Hey thanx shiva. This helps me understanding the floor. But if u see

example given by jagan, floor(10.22,5) should give 10 but according to

jagan it give 5 . can u help in dis?

On 26-Feb-2015 4:05 PM, "Shiva Kumar Thoutam" <qcwebmaster@qlikview.com>

Re: Prob regarding Floor ?

CELAMBARASAN — Thu, 26 Feb 2015 11:14:36 GMT

That would be a typo

Re: Prob regarding Floor ?

nikhilgarg — Thu, 26 Feb 2015 11:19:11 GMT

Ohk, so you mean: floor(10.22, 5) returns 10. Isn't it ??

And also does offset subtracts that much value from returned value ?

Re: Prob regarding Floor ?

Anonymous — Thu, 26 Feb 2015 11:20:12 GMT

yes nikhil its typo

floor(10.22, 5) returns 10 --- it 's rounding by multiples of 5

Re: Prob regarding Floor ?

nikhilgarg — Thu, 26 Feb 2015 11:25:47 GMT

Hey,

I just checked the link but no webpage was there.

tHanks