Hi,
How do you filter a data field where it is null? I don’t see any option under the filter type and condition.
Many thanks!
If you only want the rows where it’s null, you can create your filter like this:
1 Like
Change the filter type to “Custom filter”. In your screenshot you have “Custom filter list” selected.
1 Like
please see my second screenshot where i changed the filter type
Do you see the “Null options” dropdown list for any of your filters? Try adding filters on different fields and see if you can see it. It’s weird that you can’t see it.
I can see it on any type of field - text field, number field, calculated field, etc.
1 Like
i tried using text, date and number…and all looked the same, no null option.
I am using json import file, but that shouldn’t matter, right?
Oh, guess what?
I can see the null option if I use filter in analysis, but not in “edit data”.
Do you see null option in “edit data”? @David_Wong
Yes, I was actually referring to filters at the analysis level. I didn’t realize you were trying to filter in your dataset. There are fewer options available when filtering at the dataset level. If you really need to do it at the dataset level and if your data source is a database, you’ll have to write custom SQL to filter by null.
1 Like
Got it, thanks! Good to know about the custom SQL option as well.
And any idea how to filter for blank? Do I need to convert them to null? Or need to use custom SQL as well?
Can you try leaving the value empty like this? I’ve never tried this myself.
2 Likes
That worked perfectly!! I was typing in “” under value 
Many thanks again David.
1 Like
Thanks @David_Wong for working through this in order to provide a solution to @CWong! 
I am looking to something similar but with over 10K rows with no null values. I would like to search names in a string field with a like wildcard.