topic Conversion of Text Field to Numeric Field in QlikView https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219217#M72263 <HTML><HEAD></HEAD><BODY><P>Tom,</P><P>Have a look in the help file at the num() or num#() functions.</P><P>eg: num(ITEM#,'##########')</P><P>the '#############' is the format you wish to display the number in.</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Wed, 16 Feb 2011 18:59:37 GMT matt_crowther 2011-02-16T18:59:37Z Conversion of Text Field to Numeric Field https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219216#M72262 <HTML><HEAD></HEAD><BODY><P>I would like to convert a product code field (Item#) to a numeric field to use it in identifying types of products. It is imported daily from our ERP system as a text field.</P></BODY></HTML> Wed, 16 Feb 2011 18:52:59 GMT https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219216#M72262 2011-02-16T18:52:59Z Conversion of Text Field to Numeric Field https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219217#M72263 <HTML><HEAD></HEAD><BODY><P>Tom,</P><P>Have a look in the help file at the num() or num#() functions.</P><P>eg: num(ITEM#,'##########')</P><P>the '#############' is the format you wish to display the number in.</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Wed, 16 Feb 2011 18:59:37 GMT https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219217#M72263 matt_crowther 2011-02-16T18:59:37Z Conversion of Text Field to Numeric Field https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219218#M72264 <HTML><HEAD></HEAD><BODY><P>Thanks for your help! ...that solved my problem. I have not adjusted to the SQL syntax yet. ...I am getting there!</P><P>Tom - Bay State Milling</P></BODY></HTML> Wed, 16 Feb 2011 19:59:51 GMT https://community.qlik.com/t5/QlikView/Conversion-of-Text-Field-to-Numeric-Field/m-p/219218#M72264 2011-02-16T19:59:51Z