topic Re: How to separate number from text inside a table? in QlikView https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082421#M360587 <HTML><HEAD></HEAD><BODY><P>can u share sample </P></BODY></HTML> Wed, 30 Mar 2016 11:33:26 GMT Chanty4u 2016-03-30T11:33:26Z How to separate number from text inside a table? https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082419#M360585 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I come to you now with this little problem, I need to know how to set a where statement inside a table to indicate a separation between numbers and text inside a single column.</P><P></P><P>That is a where after I have loaded a table, I am thinking in something like: "where isnumber(dimension)", although I don't really know if "isnumber" exists, but it would be something in that area.</P><P></P><P>Thank you again for your help, and have a good day.</P></BODY></HTML> Mon, 28 Mar 2016 17:52:49 GMT https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082419#M360585 2016-03-28T17:52:49Z Re: How to separate number from text inside a table? https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082420#M360586 <HTML><HEAD></HEAD><BODY><P>If someone out there is wondering, the expression isnumber does not exists, but isnum does, and works just fine to solve this issue.</P></BODY></HTML> Mon, 28 Mar 2016 19:05:43 GMT https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082420#M360586 2016-03-28T19:05:43Z Re: How to separate number from text inside a table? https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082421#M360587 <HTML><HEAD></HEAD><BODY><P>can u share sample </P></BODY></HTML> Wed, 30 Mar 2016 11:33:26 GMT https://community.qlik.com/t5/QlikView/How-to-separate-number-from-text-inside-a-table/m-p/1082421#M360587 Chanty4u 2016-03-30T11:33:26Z