Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
try
try like this
Or using WildMatch
Where WildMatch(Product, '*Staff*');
Or using SubstringCount()
Where SubStringCount(Product,'Staff')