Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joshm43
Contributor III
Contributor III

How can I force a decimal value to round up to the next whole number for all values

Good day -

I have a need for an expression that allows me to round up to the next whole number as long as the decimal value is greater than .0.  Currently, the ROUND() function will round down if less than 0.5 and up otherwise (using a step of 1.0).

Is there a way for force the rounding to go upwards in all cases?

I am doing a date difference, and want to show a whole day in any cases where the actual date difference is less than 1.0.

Thanks,

Mitchell

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Check the Ceil function

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

Check the Ceil function

joshm43
Contributor III
Contributor III
Author

Thanks - this did the trick!