topic Re: Round to nearest thousand in QlikView https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048025#M352132 <HTML><HEAD></HEAD><BODY><P>Ah, didn't know it was that simple!</P></BODY></HTML> Thu, 21 Jan 2016 15:21:46 GMT sifatnabil 2016-01-21T15:21:46Z Round to nearest thousand https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048023#M352130 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm not able to find a good solution for rounding - floor and ceil would round up or down, but what if I wanted to just round to the nearest thousand? e.g. 500,990 should become 501,000</P></BODY></HTML> Thu, 21 Jan 2016 15:11:23 GMT https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048023#M352130 sifatnabil 2016-01-21T15:11:23Z Re: Round to nearest thousand https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048024#M352131 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Round(500990, 1000)</STRONG></P></BODY></HTML> Thu, 21 Jan 2016 15:14:50 GMT https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048024#M352131 sunny_talwar 2016-01-21T15:14:50Z Re: Round to nearest thousand https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048025#M352132 <HTML><HEAD></HEAD><BODY><P>Ah, didn't know it was that simple!</P></BODY></HTML> Thu, 21 Jan 2016 15:21:46 GMT https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048025#M352132 sifatnabil 2016-01-21T15:21:46Z Re: Round to nearest thousand https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048026#M352133 <HTML><HEAD></HEAD><BODY><P>But now you do <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Jan 2016 15:28:57 GMT https://community.qlik.com/t5/QlikView/Round-to-nearest-thousand/m-p/1048026#M352133 sunny_talwar 2016-01-21T15:28:57Z