Too much depends on how your data is organized and how the sheet is designed.
Can you hack up a sample data set in excel and a sheet that simulates your workbook? (Assuming you can't just upload a packaged workbook of your actual workbook...)
Or maybe the key you are looking for is how to do "not null".
IF NOT ISNULL([your field]) THEN ...
If you need more than that, please provide a packaged workbook.
Thanks for your reply. I attached a dummy file and left the calculated field blank. The goal is when selecting columnA-E, only not null value showing up.
I think this is what you're going for. You select a column in your parameter, and the id's available to the sheet are only the ids where the value in selected column is not null.
I've created a set on ID, and used the following condition
when 'ColumnA' then [Column A]
when 'ColumnB' then [Column B]
when 'ColumnC' then [Column C]
when 'ColumnD' then [Column D]
when 'ColumnE' then [Column E]
when 'All' then str([ID])
) > 0
The innermost part calculates for each row, returning the value of the selected column, then the outside aggregate counts how many values exist for each ID. If the count is more than 0, the id will be included in the set.
this set is available for filters, or you can segregate the data as to which Ids contain data or not in the selected column.
The attached demonstrates it, but I don't have an older version of Tableau to save it as. Should work fine in older versions though, if you follow the same setup.
Id Null Column Selector.twbx 18.3 KB
I just realized, in the attached I set the filter to display all "YES" values. I really should have set it to EXCLUDE null values. But you can take care of that.
Here's another approach you may find useful
[Calculation - Only Select NOT NULL Value]
IF NOT ISNULL([Column A]) AND [Select Column] = "ColumnA" THEN 1
ELSEIF NOT ISNULL([Column B]) AND [Select Column] = "ColumnB" THEN 1
ELSEIF NOT ISNULL([Column C]) AND [Select Column] = "ColumnC" THEN 1
ELSEIF NOT ISNULL([Column D]) AND [Select Column] = "ColumnD" THEN 1
ELSEIF NOT ISNULL([Column E]) AND [Select Column] = "ColumnE" THEN 1
ELSEIF [Select Column] = "All" THEN 1
Put [Calculation - Only Select NOT NULL Value] on the filter shelf and set to 1.
See attached workbook in version 9.3
Book1_Non-null_OO.twbx 14.0 KB
Thank you so much for your help!!
Thank you so much!! I'll definitely try.
Thank you so much!! Definitely try.