topic How to filter a text information? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199710#M58527 <HTML><HEAD></HEAD><BODY><P>Depends what you want....i used that in dinamic table on expression.....</P></BODY></HTML> Wed, 23 Jun 2010 18:59:53 GMT 2010-06-23T18:59:53Z How to filter a text information? https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199707#M58524 <HTML><HEAD></HEAD><BODY><P>I've a text SQL table named "Salesman" with the following data:</P><P>- John 130 South<BR />- Jack 342 North<BR />- Mike 130 South</P><P>How can I list only the fields with '130' in the field?</P><P></P><P></P></BODY></HTML> Wed, 23 Jun 2010 17:27:43 GMT https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199707#M58524 2010-06-23T17:27:43Z How to filter a text information? https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199708#M58525 <HTML><HEAD></HEAD><BODY><P>Try this!!!</P><P>=IF(Salesman like '*130*', Salesman )</P></BODY></HTML> Wed, 23 Jun 2010 17:42:23 GMT https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199708#M58525 2010-06-23T17:42:23Z How to filter a text information? https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199709#M58526 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>This information I insert in Sort tab, Expression?</P><P></P><P>Thanks</P><P></P></BODY></HTML> Wed, 23 Jun 2010 17:56:21 GMT https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199709#M58526 2010-06-23T17:56:21Z How to filter a text information? https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199710#M58527 <HTML><HEAD></HEAD><BODY><P>Depends what you want....i used that in dinamic table on expression.....</P></BODY></HTML> Wed, 23 Jun 2010 18:59:53 GMT https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199710#M58527 2010-06-23T18:59:53Z How to filter a text information? https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199711#M58528 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>if(Subfield(Salesman,' ',2) = 130)</P><P></P></BODY></HTML> Wed, 23 Jun 2010 20:57:29 GMT https://community.qlik.com/t5/QlikView/How-to-filter-a-text-information/m-p/199711#M58528 2010-06-23T20:57:29Z