topic Re: Number Data in QlikView https://community.qlik.com/t5/QlikView/Number-Data/m-p/878992#M306856 <HTML><HEAD></HEAD><BODY><P>Give us more details please ...</P><P></P><P>Generally you can use string functions to take only a part of a string but I need to know the structure of your data</P></BODY></HTML> Wed, 15 Jul 2015 12:50:22 GMT alexandros17 2015-07-15T12:50:22Z Number Data https://community.qlik.com/t5/QlikView/Number-Data/m-p/878991#M306855 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have field in that i have numbers &amp; Text Data..</P><P></P><P>I want only number data in application.</P><P></P><P>how to do it</P><P></P><P>Regards,</P><P>Mayuri</P></BODY></HTML> Wed, 15 Jul 2015 12:48:44 GMT https://community.qlik.com/t5/QlikView/Number-Data/m-p/878991#M306855 QlikAngel 2015-07-15T12:48:44Z Re: Number Data https://community.qlik.com/t5/QlikView/Number-Data/m-p/878992#M306856 <HTML><HEAD></HEAD><BODY><P>Give us more details please ...</P><P></P><P>Generally you can use string functions to take only a part of a string but I need to know the structure of your data</P></BODY></HTML> Wed, 15 Jul 2015 12:50:22 GMT https://community.qlik.com/t5/QlikView/Number-Data/m-p/878992#M306856 alexandros17 2015-07-15T12:50:22Z Re: Number Data https://community.qlik.com/t5/QlikView/Number-Data/m-p/878993#M306857 <HTML><HEAD></HEAD><BODY><P>Load * From YourFileName </P><P>Where IsNum(YourFieldName);</P></BODY></HTML> Wed, 15 Jul 2015 12:50:26 GMT https://community.qlik.com/t5/QlikView/Number-Data/m-p/878993#M306857 MK_QSL 2015-07-15T12:50:26Z Re: Number Data https://community.qlik.com/t5/QlikView/Number-Data/m-p/878994#M306858 <HTML><HEAD></HEAD><BODY><P>Hi Mayuri,</P><P></P><P>try the ISNUM() formula - that returns -1 when it is true (if the field_content is numeric), 0 otherwise.</P><P></P><P>HtH</P></BODY></HTML> Wed, 15 Jul 2015 12:50:54 GMT https://community.qlik.com/t5/QlikView/Number-Data/m-p/878994#M306858 datanibbler 2015-07-15T12:50:54Z Re: Number Data https://community.qlik.com/t5/QlikView/Number-Data/m-p/878995#M306859 <HTML><HEAD></HEAD><BODY><P>Use the IsNum() function to filer out numbers only.</P></BODY></HTML> Wed, 15 Jul 2015 12:51:26 GMT https://community.qlik.com/t5/QlikView/Number-Data/m-p/878995#M306859 Anonymous 2015-07-15T12:51:26Z