topic Format Text Box in QlikView https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203295#M60699 <HTML><HEAD></HEAD><BODY><P>thank you !</P></BODY></HTML> Sat, 26 Jun 2010 04:41:11 GMT Anonymous 2010-06-26T04:41:11Z Format Text Box https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203292#M60696 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a text box which displays a value on megabytes, the data ranged between 2-12 digits , i dont want the data to display after the decimal point , how do i format this , for eg: the values is 12,349.23456, i just want 12,349</P><P>Please Help</P><P></P><P></P></BODY></HTML> Fri, 25 Jun 2010 20:50:56 GMT https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203292#M60696 Anonymous 2010-06-25T20:50:56Z Format Text Box https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203293#M60697 <HTML><HEAD></HEAD><BODY><P>Use the num() function, have a look in help to see how to format this</P></BODY></HTML> Fri, 25 Jun 2010 21:29:27 GMT https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203293#M60697 2010-06-25T21:29:27Z Format Text Box https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203294#M60698 <HTML><HEAD></HEAD><BODY><P>The simpliest way is to use floor() function. Just keep in mind that is not the same as rounding.</P></BODY></HTML> Sat, 26 Jun 2010 03:31:12 GMT https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203294#M60698 Anonymous 2010-06-26T03:31:12Z Format Text Box https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203295#M60699 <HTML><HEAD></HEAD><BODY><P>thank you !</P></BODY></HTML> Sat, 26 Jun 2010 04:41:11 GMT https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203295#M60699 Anonymous 2010-06-26T04:41:11Z Format Text Box https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203296#M60700 <HTML><HEAD></HEAD><BODY><P>thank you !</P></BODY></HTML> Sat, 26 Jun 2010 04:41:20 GMT https://community.qlik.com/t5/QlikView/Format-Text-Box/m-p/203296#M60700 Anonymous 2010-06-26T04:41:20Z