Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where Statement

If i wanted to add in a where statement to show any customer containing a certain word or words how would i write that? i want to only show 1 customer out of lets say 20 customers but that one customer has 10 different stores, so how could i say i want to see everything containing that main name of that customer?

Ex. CUSTOMER (just want to show everything that includes this word so it would include both of the below)

          - CUSTOMER123

          -CUSTOMER456

thanks for the help!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Load Customer, * from TableName

Where Wildmatch(Customer,'*SearchField*');

View solution in original post

1 Reply
MK_QSL
MVP
MVP

Load Customer, * from TableName

Where Wildmatch(Customer,'*SearchField*');