productgroup

[thewillemzelluf]

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!

[Chanty4u]

try

1. WHERE ProductLIKE '*Staff*';

[Chanty4u]

try like this

1. WHERE Product LIKE '*Staff*';

[sunny_talwar]

Or using WildMatch

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

[christophebrault]

Or using SubstringCount()

Where SubStringCount(Product,'Staff')