Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Creator
Creator

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
Chanty4u
MVP
MVP

try

  1. WHERE ProductLIKE '*Staff*';
Chanty4u
MVP
MVP

try like this

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

Or using WildMatch

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

christophebrault
Specialist
Specialist

Or using SubstringCount()

Where SubStringCount(Product,'Staff')

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin