Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Rahul6
Contributor
Contributor

Ceil

How does the ceil and floor functions work on negative scale I meant to say if step interval is negative 

Ex:(1.1,-2)

3 Replies
Or
MVP
MVP

Should be identical to Floor(1.1,2), I believe. Not sure why you'd want to do that, though.

stevejoyce
Specialist II
Specialist II

Agree with @Or .  -step in ceil = +step in floor and vice versa.

Rahul6
Contributor
Contributor
Author

I was already getting the results as you explained before I posted this query ...even I made my own perception that in limits if  the value is negative the lower and upper values are will be in contrast with the upper and lower values of the  positive ones ...so I thought ceil and floor are interchanging their roles when it comes to negative step interval ....but before concluding it to myself I wanted Someone to spare their opinions ..so thank you guys for your help 

Community Browser