How to filter rows with empty values on a view in UX?

Hi folks,

in some reasons, i need to filter rows based on “empty” or “not empty” on views

Create a slice to do the filtering then put a view atop that slice.

Thank you @Steve . But i can’t create new view just for this situation.
As I see, Filter section works with “contains” operator. I think, I can’t change this.

1 Like

Oh, that filter. There are no configuration options for the built-in filtering that would allow you to activate empty/not-empty selection. The best you could do is add another column to your table that reflects the empty/not-empty status of the other column. You could then use that in the built-in filtering.

I think best approach is:

define initial value for your column. (Ex. “null”). So you can filter “null” values:)

1 Like

Excellent idea!