Solved: can please explain me floor and ceil functions - Qlik Community

Vijayqlik4171 · ‎2021-09-14

floor(2.8)=returns 2

ceil(2.8)=returns 3

i know above two scenarios

but how it calculate below scenarios?

Floor( 2,4 ): returns 0 ?

Floor( 1.1 , 1 , 0.5 )returns 0.5 ?

Ceil( 3.88 , 5 ) returns 5 ?

Ceil( 1.1 , 1 , -0.01 )returns 1.99 ?

tresesco · ‎2021-09-14

Yes, initially it needs a bit of explanation, I have seen that with many (including me). Have a look at the explanation given by @nagaiank and Stefan @swuehl at this post : https://community.qlik.com/t5/QlikView-App-Dev/Doubts-in-understanding-the-ceil-and-floor-functions/...

MayilVahanan · ‎2021-09-14

Hi Vijay,

It depends on step & offset. Please refer the same in below screenshot & url.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

tresesco · ‎2021-09-14

Yes, initially it needs a bit of explanation, I have seen that with many (including me). Have a look at the explanation given by @nagaiank and Stefan @swuehl at this post : https://community.qlik.com/t5/QlikView-App-Dev/Doubts-in-understanding-the-ceil-and-floor-functions/...