4 Replies Latest reply: Jun 13, 2018 5:32 AM by Christophe Brault RSS

    productgroup

    willem van der Plas

      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!