There are some ideas on this thread: http://community.tableau.com/thread/105407
Basically you can a) create a SET from the filtered field and exclude NULLs (via Andy Cotgreave) -- right click the field, do "Create Set", click NULL and click the Exclude button in the bottom right, and use the resulting set as a quick filter
or you can b) "duplicate your field. filter on the duplicate field and exclude nulls. [Then] Add your original field as a quickfilter, but chose the option to show only relevant values." via Matt Morgenroth
Hi Chip. Thanks for the speedy response. I went with the set approach (thanks for the refresher on that) but my resulting set is grayed out (disabled). What am I doing wrong here?
I'd love to see a simple example of this in practice, if anyone can post a sample workbook.
I've attached a workbook that has a very simple example. I took one of the Tableau example data sets and converted a few States to NULL, then excluded them in a set and put a filter on it. Nothing is grey, so it's working here -- you may want to check that your solution looks similar.
If you still have issues, you can attach a packaged workbook that exhibits the behavior you're seeing, so we have more to go on.
Hope this helps,
Thanks. I don't have a use case for this at the moment, I was just curious about the methodology. Cheers
Excellent. Thanks for the visual. I did exactly that but for some reason my set is disabled - I can't use it. Not sure why. Maybe it's because the filter it references is based on a calculated field instead of a set of data.
I wish I could share my data with you but I work in the Health Care industry and would have to do a whole lot of redacting to share anything. Sorry about that.
Yeah, I'm in Healthcare too, so I've made a study of building examples out of the Tableau sample data. :-) If you can build a similar calculation and filter using one of the sample Tableau datasets and somehow recreate the problem, that's often sufficient. Just not sure how else to help, sorry!