topic supress zeros in QlikView https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213446#M67171 <HTML><HEAD></HEAD><BODY><P>hi Robson,</P><P>You can use Num function</P><P>num(Customer number)</P></BODY></HTML> Fri, 11 Feb 2011 20:17:42 GMT deepakk 2011-02-11T20:17:42Z supress zeros https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213444#M67169 <HTML><HEAD></HEAD><BODY><P>How can I supress zeros in an char field?</P><P>Example: customer number = 00003212</P><P>I want let it as '3312' direct in the script</P></BODY></HTML> Fri, 11 Feb 2011 20:14:59 GMT https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213444#M67169 rcandeo 2011-02-11T20:14:59Z supress zeros https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213445#M67170 <HTML><HEAD></HEAD><BODY><P>Hello Robson,</P><P>The fastest way is converting it to a number with Num(Field) which will represent the value as as integer in this case.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Num(CustomerNumber) AS CustomerNumber,</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Fri, 11 Feb 2011 20:16:57 GMT https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213445#M67170 Miguel_Angel_Baeyens 2011-02-11T20:16:57Z supress zeros https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213446#M67171 <HTML><HEAD></HEAD><BODY><P>hi Robson,</P><P>You can use Num function</P><P>num(Customer number)</P></BODY></HTML> Fri, 11 Feb 2011 20:17:42 GMT https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213446#M67171 deepakk 2011-02-11T20:17:42Z supress zeros https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213447#M67172 <HTML><HEAD></HEAD><BODY><P>Convert using the Num function.</P></BODY></HTML> Fri, 11 Feb 2011 20:24:31 GMT https://community.qlik.com/t5/QlikView/supress-zeros/m-p/213447#M67172 2011-02-11T20:24:31Z