topic Re: Ceil,Floor in QlikView

Ceil,Floor

Wed, 08 May 2013 10:34:43 GMT

Hi Community Experts,

Can you please help me out in understanding below functions.

When we use ceil,floor,round functions with parameters like below, giving the results mentioned. But I am not getting how it working. Can you give some explanation for those with parameters. Like Ceil(2.6,0.25) ,Floor(2.6,0.25) etc

Ceil(2.5) 3

Ceil(2.6, 0.25) 2.75

Floor(2.5) 2

Floor(2.6, 0.25) 2.5

Round(3.14) 3

Round(3.16, 0.1) 3.20

Round(3.14, 0.1) 3.10

Thanks

Suneela

Re: Ceil,Floor

kumarnatarajan — Wed, 08 May 2013 10:51:23 GMT

Hi,

Refer this link

http://community.qlik.com/message/337447

Re: Ceil,Floor

anandathome — Wed, 08 May 2013 10:58:17 GMT

Hi Suneela,

You can refer pages 304,305 and 804,805 in the Qlikview Reference manual for a good explanation.

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

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

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

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

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.

-Anand.

Re: Ceil,Floor

Wed, 08 May 2013 11:19:22 GMT

Guys that was really very helpful, it works in my project. I was seeking for this months ago. anti fatigue comfort mats

Re: Ceil,Floor

Wed, 08 May 2013 11:38:27 GMT

thanks all.

It really helped. But can you explain when we given expression like below.

It does not have base. Then how it will work.What will it assume for base, or whether 0.5 is base or offset?

Ceil(2.6,0.25)=2.75

Re: Ceil,Floor

anandathome — Wed, 08 May 2013 11:48:53 GMT

Here 0.25 is just the base with no offset.

So your result will be in multiples of 0.25

Re: Ceil,Floor

kumarnatarajan — Wed, 08 May 2013 12:07:33 GMT

Hi,

Ceil(2.6,0.25)=2.75

If apply the offset 0.25, you get 0.25, 0.50, 0.75, 1.00, 1.25

The nearest higher number for 2.6 is 2.75 and so ceil returns 2.75