1 Reply Latest reply on Apr 10, 2012 7:49 AM by Mark Holtz

Filter Rows based on Conditions on Multiple Columns

sinadashtipour Apr 10, 2012 7:04 AM

Hi All,

As the title reads, I simply would like to filter my rows based on specific values on the different columns, for example see table below:

I need to filter to only show rows where Cold D has a date (i.e. NOT null or 0-0-0) AND Col A, Col B,Col C are null OR 0-0-0.

So table above should filter to only rows: 1,3,6,10

Is this possible?

Thanks

1. Re: Filter Rows based on Conditions on Multiple Columns

Mark Holtz Apr 10, 2012 7:49 AM (in response to sinadashtipour)

You could create a calculated field and then filter based on the result of the formula:

Create "Filter Formula 1" as
IF IFNULL([Col D] ,'0-0-0') <> '0-0-0'
     AND IFNULL([ColA],'') <> ''
     AND IFNULL([ColB],'') <> ''
     AND IFNULL([ColC],'') <> ''
THEN 'Show'
ELSE 'Hide'
END

Then filter on your calculated field to display 'Show' only.
Like Show 0 Likes(0)

Actions

Tableau Community Forums