topic Re: Rounding off in QlikView https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383686#M1167152 <HTML><HEAD></HEAD><BODY><P>Good work Janssen</P></BODY></HTML> Tue, 04 Sep 2012 08:46:31 GMT siva0606 2012-09-04T08:46:31Z Rounding off https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383683#M1167149 <HTML><HEAD></HEAD><BODY><P>How do I round off to the nearest hundred in Qlikview</P></BODY></HTML> Tue, 04 Sep 2012 08:05:08 GMT https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383683#M1167149 2012-09-04T08:05:08Z Re: Rounding off https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383684#M1167150 <HTML><HEAD></HEAD><BODY><P>Hi, Round(yourvalue, 100). Regards, Sander</P><P></P></BODY></HTML> Tue, 04 Sep 2012 08:09:23 GMT https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383684#M1167150 Anonymous 2012-09-04T08:09:23Z Re: Rounding off https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383685#M1167151 <HTML><HEAD></HEAD><BODY><P>Hi Sander.&nbsp; Thank you .&nbsp; It worked.&nbsp; Much appreciated. </P><P>I see the error in my formula .&nbsp; I had&nbsp; if ([Stock Required] &lt; 0.01 , 0 , Round(100))</P></BODY></HTML> Tue, 04 Sep 2012 08:27:41 GMT https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383685#M1167151 2012-09-04T08:27:41Z Re: Rounding off https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383686#M1167152 <HTML><HEAD></HEAD><BODY><P>Good work Janssen</P></BODY></HTML> Tue, 04 Sep 2012 08:46:31 GMT https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383686#M1167152 siva0606 2012-09-04T08:46:31Z Re: Rounding off https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383687#M1167153 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; When I logged out and logged back in, i saw many replies of the same message.</P></BODY></HTML> Tue, 04 Sep 2012 08:49:38 GMT https://community.qlik.com/t5/QlikView/Rounding-off/m-p/383687#M1167153 2012-09-04T08:49:38Z