topic Cast string to number in QlikView https://community.qlik.com/t5/QlikView/Cast-string-to-number/m-p/371245#M138078 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I am trying to cast a string to number, the string is formated as this. 0000000000000234.</P><P>I am trying usign num function but doesn't work. I need to get the 234 only.</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 27 Jun 2012 19:21:46 GMT 2012-06-27T19:21:46Z Cast string to number https://community.qlik.com/t5/QlikView/Cast-string-to-number/m-p/371245#M138078 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I am trying to cast a string to number, the string is formated as this. 0000000000000234.</P><P>I am trying usign num function but doesn't work. I need to get the 234 only.</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 27 Jun 2012 19:21:46 GMT https://community.qlik.com/t5/QlikView/Cast-string-to-number/m-p/371245#M138078 2012-06-27T19:21:46Z Re: Cast string to number https://community.qlik.com/t5/QlikView/Cast-string-to-number/m-p/371246#M138079 <HTML><HEAD></HEAD><BODY><P>Try this to discard zeros</P><P>replace(LTrim(Replace(Field, 0,' ')), ' ',0)</P></BODY></HTML> Wed, 27 Jun 2012 19:39:45 GMT https://community.qlik.com/t5/QlikView/Cast-string-to-number/m-p/371246#M138079 chematos 2012-06-27T19:39:45Z