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: 
jenmclean
Contributor III
Contributor III

Exclude certain data by row

This is a sample of a chart I am working on. In the Vendor Inv column as well as the Notes column, AP puts in the trigger CLEAR in either one or both of these fields. The end use of the report is to export into Excel with the final output being uploaded in the software that generates the actual printing of the checks.

I need to exclude any rows that have the trigger CLEAR in it.

How would I either script it or write an expression to handle this.

Thanks in advance!

Exclude CLEAR.png

10 Replies
jenmclean
Contributor III
Contributor III
Author

Thanks everyone, I had to rethink the data but all your comments helped me so sort it out.