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: 
Not applicable

Filtering by null

Dear QLIKies,

How do I filter data by null?

My scenario is as thus, I have 2 tables (2 excel files). Both shared a common field. But I wanna list out those records in tableA that is not found in tableB (missing common field).

11 Replies
hic
Former Employee
Former Employee

This is described in the following blog post: Finding NULL

The method is the same in Qlik Sense as in QlikView. However, the "Select Excluded" is found by clicking the search icon, then the three dots:

Sense Select Excluded.png

HIC

Not applicable
Author

Much thanks Henric, it is solved.

And also Christoph and Kees.