Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thewillemzelluf
New Contributor II

productgroup

Hello everyone,

I would like to select on a certain group of products. However, there is a lot of data contamination in the database so I have to apply a filter. Because I want to select on a certain product group. the problem is that there are several product groups hanging on a product. The group on which I want to select always has the characteristic 'staff' in it.

In SQL I would namely do the following:

WHERE PRODUCT GROUP LIKE '% staff%'

Someone an idea how I can do this Qlik?

Thanks in advance!

4 Replies
sureshqv
Esteemed Contributor III

Re: productgroup

try

  1. WHERE ProductLIKE '*Staff*';
sureshqv
Esteemed Contributor III

Re: productgroup

try like this

  1. WHERE Product LIKE '*Staff*';
MVP
MVP

Re: productgroup

Or using WildMatch

Where WildMatch(Product, '*Staff*');

christophebraul
Contributor III

Re: productgroup

Or using SubstringCount()

Where SubStringCount(Product,'Staff')