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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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

@MegL  try below

LOAD *

FROM Table

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