topic Ceil funtion in QlikView https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337037#M124272 <HTML><HEAD></HEAD><BODY><P> i have value in decimal points like 2.3567890 and i want to show rounded value like 2.357, so guide me how&nbsp; i use ceil function to achive result</P></BODY></HTML> Tue, 06 Mar 2012 06:45:52 GMT 2012-03-06T06:45:52Z Ceil funtion https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337037#M124272 <HTML><HEAD></HEAD><BODY><P> i have value in decimal points like 2.3567890 and i want to show rounded value like 2.357, so guide me how&nbsp; i use ceil function to achive result</P></BODY></HTML> Tue, 06 Mar 2012 06:45:52 GMT https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337037#M124272 2012-03-06T06:45:52Z Ceil funtion https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337038#M124273 <HTML><HEAD></HEAD><BODY><P>Hi zain,</P><P></P><P> Ceil(2.3567890, 0.001) should do the trick <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>-Teemu</P></BODY></HTML> Tue, 06 Mar 2012 06:51:09 GMT https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337038#M124273 teempi 2012-03-06T06:51:09Z Ceil funtion https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337039#M124274 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Many ways you can achieve it</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Num(2.3567890, 0.000)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Round(2.3567890, 0.001)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ceil(2.3567890, 0.001)</P><P></P><P>Hope it helps</P><P>Celambarasan</P></BODY></HTML> Tue, 06 Mar 2012 06:54:50 GMT https://community.qlik.com/t5/QlikView/Ceil-funtion/m-p/337039#M124274 CELAMBARASAN 2012-03-06T06:54:50Z