Creating multiple filters

Question

I'm trying to create multiple filters on one dataset. Right now I'm following the below procedure but is there anyway I can cut this short?

1) Filter 1 - Remove zeroes in column 'value'.

2) Filter 2 - Remove Nulls in column 'value'.

3) Filter 3 - Remove records 'total' in column 'F1'.

3) Filter 4 - Remove records 'total' in column 'Name'.

Capture.PNG

Thableaus · Accepted Answer

Hi @vvissamsetty

Yes it can with OR operator, using a single filter tool.

!(Value = 0 OR IsNull(Value) OR Contains([F1], "Total") OR Contains ([Name], "Total"))

Cheers,