Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rounding off

How do I round off to the nearest hundred in Qlikview

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi, Round(yourvalue, 100). Regards, Sander

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hi, Round(yourvalue, 100). Regards, Sander

Not applicable
Author

Hi Sander.  Thank you .  It worked.  Much appreciated.

I see the error in my formula .  I had  if ([Stock Required] < 0.01 , 0 , Round(100))

siva0606
Contributor III
Contributor III

Good work Janssen

Not applicable
Author

sorry for the many replies, its initially said that there was an error and my reply did not go through. So i did it again.  When I logged out and logged back in, i saw many replies of the same message.