Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-12-12 04:00 PM

How to simulate the Excel RoundUp function.

Does anyone know how to simulate the Excel RoundUp function in the QV script?  I need to round 1.2 up to the number 2.   Thanks.

709 Views
0 Likes
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2012-12-12 04:01 PM

hi

Try like this

Ceil() concept

=Ceil(1.2) gives 2

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

View solution in original post

338 Views
2 Replies
MayilVahanan
MVP
MVP
‎2012-12-12 04:01 PM

hi

Try like this

Ceil() concept

=Ceil(1.2) gives 2

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
339 Views
Not applicable
‎2012-12-12 04:06 PM
Author

In response to MayilVahanan

That worked.  Thanks!

338 Views
0 Likes