topic Re: Number formate in QlikView https://community.qlik.com/t5/QlikView/Number-formate/m-p/681147#M246945 <HTML><HEAD></HEAD><BODY><P>use</P><P></P><P>ceil(0.0008945, 0.0001)</P></BODY></HTML> Wed, 08 Oct 2014 12:06:01 GMT alexandros17 2014-10-08T12:06:01Z Number formate https://community.qlik.com/t5/QlikView/Number-formate/m-p/681145#M246943 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P>my number is 0.0008945 i want to to display only 0.006 formate means after point i want to display only 3 digits.</P><P>please help me..</P><P>Regards,</P><P>Chandini.g</P></BODY></HTML> Wed, 08 Oct 2014 12:00:55 GMT https://community.qlik.com/t5/QlikView/Number-formate/m-p/681145#M246943 Anonymous 2014-10-08T12:00:55Z Re: Number formate https://community.qlik.com/t5/QlikView/Number-formate/m-p/681146#M246944 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>Num([Your Number], '#.###')</P><P>or</P><P>round([Your Number], 0.001)</P></BODY></HTML> Wed, 08 Oct 2014 12:04:08 GMT https://community.qlik.com/t5/QlikView/Number-formate/m-p/681146#M246944 senpradip007 2014-10-08T12:04:08Z Re: Number formate https://community.qlik.com/t5/QlikView/Number-formate/m-p/681147#M246945 <HTML><HEAD></HEAD><BODY><P>use</P><P></P><P>ceil(0.0008945, 0.0001)</P></BODY></HTML> Wed, 08 Oct 2014 12:06:01 GMT https://community.qlik.com/t5/QlikView/Number-formate/m-p/681147#M246945 alexandros17 2014-10-08T12:06:01Z Re: Number formate https://community.qlik.com/t5/QlikView/Number-formate/m-p/681148#M246946 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P>Thanks for reply...</P><P>Regards,</P><P>Chandini</P></BODY></HTML> Wed, 08 Oct 2014 12:11:05 GMT https://community.qlik.com/t5/QlikView/Number-formate/m-p/681148#M246946 Anonymous 2014-10-08T12:11:05Z