Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ROUNDUP, without ROUND

ROUNDUP, without ROUND

Best regards

I wish rounding the result to the maximum without ROUND, since it makes if the decimal is 5 or above is rounded, otherwise it does not. Example: round (2.4) returns 2; round (2.6 returns 3), but I need you round all, example: XX (2.2) = 3; XX (2.5) = 3. something similar to excel, when used "roundup"

I would appreciate your valuable assistance

thank you very much

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Use the CEIL() function in the same way as round - always "rounds" up.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Agis-Kalogiannis
Employee
Employee

Yeap. ceil() function will do exactly what you want and floor() will do exactly the opposite. 🙂

Agis

buzzy996
Master II
Master II

from reference manual,

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

Rounding of x upwards to the nearest multiple of base with an offset

of offset. The result is a number.

Examples:

ceil( 2.4 ) returns 3

ceil( 2.6 ) returns 3

ceil( 3.88 , 0.1 ) returns 3.9

ceil( 3.88 , 5 ) returns 5

ceil( 1.1 , 1 , 0.5 ) returns 1.5

Not applicable
Author

I would appreciate your help it works perfect

buzzy996
Master II
Master II

ur wc,if u are happy with tht..pls mark as correct.

oknotsen
Master III
Master III

If your questions is answered, please flag the correct answer so the topic is flagged as answered. Thank you.

May you live in interesting times!