topic Re: Floor Function in QlikView

Floor Function

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a question about Floor Function. Could someone explain how Floor(3.5,-0.5) results in 4.0? I was thinking that it would result in 3.0

Any help will be greatly appreciated

Re: Floor Function

Clever_Anjos — Wed, 11 May 2016 17:48:19 GMT

Into version 12 returns 3.5 that is consistent since you are passing a "step" parameter 0.5

If you want to floor to next integer use Floor(3.5)

Re: Floor Function

Chanty4u — Thu, 12 May 2016 04:57:20 GMT

chk dis too

Try = Floor(3.5)

Rounding Errors

Re: Floor Function

jonathandienst — Thu, 12 May 2016 05:21:06 GMT

Floor Rounds down to the nearest multiple of the second parameter (to the precision of the second parameter).

Floor(3.6) -- > 3

Floor(3.6, 0.5) -- > 3.5

Floor(3.6, 0.1) -- > 3.6

(In all versions of QV that I have used)

Re: Floor Function

Thu, 12 May 2016 11:22:22 GMT

Hi,

Refer to the following link :

Floor Function Details

Regards,

Snehal Nabar

Re: Floor Function

jharke — Mon, 04 Jul 2016 09:44:54 GMT

Hello Rahul,

You use a Floor function (= kind of rounding down) with a minus-sign after the comma, that means that it is rounding up.

As a matter of fact, you use kind of Ceil(3.5,0.5).

(If you delete the minus sign, I think the result wil be 3.5)

(I wonder why the result of Floor(3.5,-0.5) would be 4. maybe 3.5 is a bit more, e.g. 3.5000001?)

Re: Floor Function

Anonymous — Fri, 16 Dec 2016 11:55:18 GMT

why we using Floor Function?

Re: Floor Function

Clever_Anjos — Mon, 19 Dec 2016 21:46:19 GMT

I think floor is the topic, right?

Re: Floor Function

Anonymous — Tue, 20 Dec 2016 08:37:07 GMT

sure, floor is topic but which type of scenario can be use?

Re: Floor Function

Clever_Anjos — Tue, 20 Dec 2016 13:05:55 GMT

Several cases:

You have a frac number 4.678 for example and want to round to smallest 4
You have a frac number 4.678 for example and want to round to smallest 4.6
You have a datetime field and want to extract the date part Date(Floor(yourfield))

Re: Floor Function

Anonymous — Tue, 13 Feb 2018 06:09:27 GMT

Floor(3.5,-0.5) results in 3 not 4

if it is more than single fraction 3.5 i.e Floor(3.57,-0.5) will result in 4

same wise 0.1 also behaves Floor(3.68,-0.1)---->3.7 where as

Floor(3.6,-0.1)----->3.6

Floor(3.68,-0.1)---->3.7

Floor(3.6,-0.5)-----> 4

Floor(3.5,0.5) -----> 3.5

Floor(3.5,0.1)------> 3.5

Floor(3.6,0.1)---> 3.6

Ceil(3.4)-------> 4

Ceil(3.6)-------> 4