topic Re: Filtering dbase (sort) in QlikView https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978173#M334115 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/77201">Operator "LIKE" in QlikView?</A></P></BODY></HTML> Wed, 23 Dec 2015 11:02:55 GMT 2015-12-23T11:02:55Z Filtering dbase (sort) https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978171#M334113 <HTML><HEAD></HEAD><BODY><P>I have 3 fields and i want to filter out with a key word how do i do it?</P><P>See example:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>S/N</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Comp</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Amount</STRONG></P></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Afrihob Shop</TD><TD style="padding: 2px;">200</TD></TR><TR><TD>2</TD><TD>Mavrikshop</TD><TD>400</TD></TR><TR><TD>3</TD><TD>Deco Shores</TD><TD>300</TD></TR><TR><TD>4</TD><TD>SirV Sp</TD><TD>230</TD></TR><TR><TD>5</TD><TD>Genesis</TD><TD>100</TD></TR><TR><TD>6</TD><TD>Marikosshop</TD><TD>201</TD></TR><TR><TD>7</TD><TD>Merit SHop</TD><TD>40</TD></TR></TBODY></TABLE><P></P><P>I want to filter my database using "Where" to pick only the Comp having Shop, SHop or Sp</P></BODY></HTML> Wed, 23 Dec 2015 10:55:59 GMT https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978171#M334113 2015-12-23T10:55:59Z Re: Filtering dbase (sort) https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978172#M334114 <HTML><HEAD></HEAD><BODY><P>In qlikview you could use: where wildmatch(Comp, '*Shop*', '*SHop*', '*Sp*') and per sql something like: where Comp like '*Shop*' or Comp like '*SHop*' or Comp like '*Sp*'.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 23 Dec 2015 11:01:53 GMT https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978172#M334114 marcus_sommer 2015-12-23T11:01:53Z Re: Filtering dbase (sort) https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978173#M334115 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/77201">Operator "LIKE" in QlikView?</A></P></BODY></HTML> Wed, 23 Dec 2015 11:02:55 GMT https://community.qlik.com/t5/QlikView/Filtering-dbase-sort/m-p/978173#M334115 2015-12-23T11:02:55Z