topic Re: Round Off in QlikView https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043660#M943338 <HTML><HEAD></HEAD><BODY><P>hi,<IMG alt="round.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110887_round.png" style="height: auto;" /></P></BODY></HTML> Thu, 07 Jan 2016 11:01:07 GMT Chanty4u 2016-01-07T11:01:07Z Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043652#M943328 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I have a no two nos.</P><P>2147 and 2933</P><P>I want to round of 2147 to 2000</P><P>and 2933 to 3000 Please assist.</P><P></P><P>Regards </P><P>Noman khan</P></BODY></HTML> Thu, 07 Jan 2016 10:51:05 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043652#M943328 noman212 2016-01-07T10:51:05Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043653#M943330 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp; <EM>Floor(Num('EXPRESSION'))</EM></P></BODY></HTML> Thu, 07 Jan 2016 10:53:40 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043653#M943330 Chanty4u 2016-01-07T10:53:40Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043654#M943332 <HTML><HEAD></HEAD><BODY><P>try with Floor() &amp; Ceil()...</P><P></P><P>how it is stored into data??</P></BODY></HTML> Thu, 07 Jan 2016 10:54:19 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043654#M943332 Anonymous 2016-01-07T10:54:19Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043655#M943333 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/254814#254814" title="https://community.qlik.com/message/254814#254814">https://community.qlik.com/message/254814#254814</A></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/760272#760272" title="https://community.qlik.com/message/760272#760272">https://community.qlik.com/message/760272#760272</A></P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Thu, 07 Jan 2016 10:55:24 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043655#M943333 amit_saini 2016-01-07T10:55:24Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043656#M943334 <HTML><HEAD></HEAD><BODY><P>Round(YourNumber, <STRONG>1000</STRONG>)</P></BODY></HTML> Thu, 07 Jan 2016 10:55:46 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043656#M943334 tresB 2016-01-07T10:55:46Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043657#M943335 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Round(Number/1000)*1000</STRONG></P></BODY></HTML> Thu, 07 Jan 2016 10:57:38 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043657#M943335 sunny_talwar 2016-01-07T10:57:38Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043658#M943336 <HTML><HEAD></HEAD><BODY><P>=num(round(urnum))</P></BODY></HTML> Thu, 07 Jan 2016 10:57:38 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043658#M943336 Chanty4u 2016-01-07T10:57:38Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043659#M943337 <HTML><HEAD></HEAD><BODY><P>Thanks Alot <STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/tresesco">tresesco</A></STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 07 Jan 2016 11:00:02 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043659#M943337 noman212 2016-01-07T11:00:02Z Re: Round Off https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043660#M943338 <HTML><HEAD></HEAD><BODY><P>hi,<IMG alt="round.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110887_round.png" style="height: auto;" /></P></BODY></HTML> Thu, 07 Jan 2016 11:01:07 GMT https://community.qlik.com/t5/QlikView/Round-Off/m-p/1043660#M943338 Chanty4u 2016-01-07T11:01:07Z