topic Numbers without Symbols in QlikView https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305621#M112878 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My sales column have values with some special characters. But, I want to take only numeric values from that.</P><P>which function is use.</P><P>Let me know,</P><P></P><P>Thanks &amp; Regards,</P><P>Sri</P></BODY></HTML> Tue, 21 Jun 2011 07:40:51 GMT 2011-06-21T07:40:51Z Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305621#M112878 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My sales column have values with some special characters. But, I want to take only numeric values from that.</P><P>which function is use.</P><P>Let me know,</P><P></P><P>Thanks &amp; Regards,</P><P>Sri</P></BODY></HTML> Tue, 21 Jun 2011 07:40:51 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305621#M112878 2011-06-21T07:40:51Z Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305622#M112879 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>Can you send ur doc with .Doc extension instead of docx</P><P></P><P></P><P>-Jai</P></BODY></HTML> Tue, 21 Jun 2011 07:43:18 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305622#M112879 2011-06-21T07:43:18Z Re: Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305623#M112880 <HTML><HEAD></HEAD><BODY><P>Dear Jai,</P><P></P><P>Please find the attachment.</P><P></P><P>Thanks &amp; Regards,</P><P>Sri</P></BODY></HTML> Tue, 21 Jun 2011 07:46:33 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305623#M112880 2011-06-21T07:46:33Z Re: Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305624#M112881 <HTML><HEAD></HEAD><BODY><P>Sorry chk with this attachment</P></BODY></HTML> Tue, 21 Jun 2011 07:50:27 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305624#M112881 2011-06-21T07:50:27Z Re: Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305625#M112882 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; Find the atatchment</P><P></P><P>-Jai</P></BODY></HTML> Tue, 21 Jun 2011 07:53:44 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305625#M112882 2011-06-21T07:53:44Z Re: Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305626#M112883 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is what i want...</P><P>Thanks alot jai</P><P></P><P>Regards,</P><P>Sri</P></BODY></HTML> Tue, 21 Jun 2011 08:04:11 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305626#M112883 2011-06-21T08:04:11Z Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305627#M112884 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"></SPAN></P><P>keepchar(Sales,'0123456789') will give better result and dynamic</P><P></P></BODY></HTML> Tue, 21 Jun 2011 08:11:35 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305627#M112884 SunilChauhan 2011-06-21T08:11:35Z Numbers without Symbols https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305628#M112885 <HTML><HEAD></HEAD><BODY><P>Ya,,</P><P>Thanks alot sunil</P></BODY></HTML> Tue, 21 Jun 2011 10:23:26 GMT https://community.qlik.com/t5/QlikView/Numbers-without-Symbols/m-p/305628#M112885 2011-06-21T10:23:26Z