topic Search in data in QlikView https://community.qlik.com/t5/QlikView/Search-in-data/m-p/719489#M672295 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a few rows of in the database that are comments made by users about handphone brands. The datafield is `comments`. These are just 2 examples,</P><P></P><P>'Overall, I prefer the iPhone 5s'</P><P>'I definitely prefer the Samsung'</P><P></P><P>I would like to filter the string and count them in terms of how many times the iPhone and Samsung was mentioned.</P><P></P><P>Thanks,</P><P>Nat</P></BODY></HTML> Thu, 21 Aug 2014 09:26:14 GMT 2014-08-21T09:26:14Z Search in data https://community.qlik.com/t5/QlikView/Search-in-data/m-p/719489#M672295 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a few rows of in the database that are comments made by users about handphone brands. The datafield is `comments`. These are just 2 examples,</P><P></P><P>'Overall, I prefer the iPhone 5s'</P><P>'I definitely prefer the Samsung'</P><P></P><P>I would like to filter the string and count them in terms of how many times the iPhone and Samsung was mentioned.</P><P></P><P>Thanks,</P><P>Nat</P></BODY></HTML> Thu, 21 Aug 2014 09:26:14 GMT https://community.qlik.com/t5/QlikView/Search-in-data/m-p/719489#M672295 2014-08-21T09:26:14Z Re: Search in data https://community.qlik.com/t5/QlikView/Search-in-data/m-p/719490#M672296 <HTML><HEAD></HEAD><BODY><P>count({&lt;comments={'*iPhone*','*Samsung*'}&gt;}comments)</P></BODY></HTML> Thu, 21 Aug 2014 11:40:08 GMT https://community.qlik.com/t5/QlikView/Search-in-data/m-p/719490#M672296 Gysbert_Wassenaar 2014-08-21T11:40:08Z