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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
MegL
Contributor
Contributor

How to exclude data

I'm new to Qlik and trying to design a dashboard.  I'd like to exclude rows from my data set if values within a column contain a string with "xxxx (a)", is there a way to do this in the data load editor or when designing the sheet. 

Labels (1)
1 Reply
Kushal_Chawda
MVP
MVP

@MegL  try below

LOAD *

FROM Table

WHERE not wildmatch(Field,'*xxxx (a)*');