topic number format in QlikView https://community.qlik.com/t5/QlikView/number-format/m-p/420091#M156294 <HTML><HEAD></HEAD><BODY><P>If i have a number like 69.9 , and i want to get the integer part,in this case it will be 69 and not 70 , can anyone give me the number format of this case?</P></BODY></HTML> Fri, 09 Nov 2012 12:57:13 GMT 2012-11-09T12:57:13Z number format https://community.qlik.com/t5/QlikView/number-format/m-p/420091#M156294 <HTML><HEAD></HEAD><BODY><P>If i have a number like 69.9 , and i want to get the integer part,in this case it will be 69 and not 70 , can anyone give me the number format of this case?</P></BODY></HTML> Fri, 09 Nov 2012 12:57:13 GMT https://community.qlik.com/t5/QlikView/number-format/m-p/420091#M156294 2012-11-09T12:57:13Z Re: number format https://community.qlik.com/t5/QlikView/number-format/m-p/420092#M156295 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>use floor function.</P></BODY></HTML> Fri, 09 Nov 2012 13:01:40 GMT https://community.qlik.com/t5/QlikView/number-format/m-p/420092#M156295 2012-11-09T13:01:40Z Re: number format https://community.qlik.com/t5/QlikView/number-format/m-p/420093#M156296 <HTML><HEAD></HEAD><BODY><P>Thank you for ur quick reply!!</P></BODY></HTML> Fri, 09 Nov 2012 13:04:27 GMT https://community.qlik.com/t5/QlikView/number-format/m-p/420093#M156296 2012-11-09T13:04:27Z