topic How to filter rows where value is not a number? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602531#M1110068 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the following table</P><P></P><P>aaaa</P><P>34</P><P>22.2</P><P>drr</P><P></P><P>and I would like to filter number rows so I obtain</P><P></P><P>24</P><P>22.2</P><P></P><P>Any hint?</P></BODY></HTML> Wed, 05 Mar 2014 09:06:17 GMT 2014-03-05T09:06:17Z How to filter rows where value is not a number? https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602531#M1110068 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the following table</P><P></P><P>aaaa</P><P>34</P><P>22.2</P><P>drr</P><P></P><P>and I would like to filter number rows so I obtain</P><P></P><P>24</P><P>22.2</P><P></P><P>Any hint?</P></BODY></HTML> Wed, 05 Mar 2014 09:06:17 GMT https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602531#M1110068 2014-03-05T09:06:17Z Re: How to filter rows where value is not a number? https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602532#M1110069 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>LOAD</P><P>*</P><P>FROM Data</P><P>Where IsNum(Value);</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 05 Mar 2014 09:13:11 GMT https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602532#M1110069 jagan 2014-03-05T09:13:11Z Re: How to filter rows where value is not a number? https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602533#M1110070 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Hope this will help you.</P></BODY></HTML> Wed, 05 Mar 2014 09:20:54 GMT https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602533#M1110070 2014-03-05T09:20:54Z Re: How to filter rows where value is not a number? https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602534#M1110071 <HTML><HEAD></HEAD><BODY><P>You WHERE ISNUM(Value);</P><P></P><P>like below</P><P></P><P><IMG alt="2014-03-05_0936.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54303_2014-03-05_0936.png" /></P></BODY></HTML> Wed, 05 Mar 2014 09:36:54 GMT https://community.qlik.com/t5/QlikView/How-to-filter-rows-where-value-is-not-a-number/m-p/602534#M1110071 rustyfishbones 2014-03-05T09:36:54Z