This content has been marked as final. Show 4 replies
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!