Native Derived Table Filter

  • 12 January 2021
  • 1 reply

Hello all,

How would I apply a NULL filter on a Native Derived Table using an explore source? I understand how to do this via SQL, but can’t figure it out for explore source. The image below is from the Looker webpage on how to use a filter. It appears to be a text based filter, so if I typed in IS NULL, it when only show me results that had a string of “IS NULL” whereas I just want all null records. Thanks for the help!


1 reply

Userlevel 1

try “NULL”


this doc shows examples of many filter expressions include null and not null