Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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:

HIC
Much thanks Henric, it is solved. ![]()
And also Christoph and Kees.