Creating multiple filters

[vvissamsetty]

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'. 

[Thableaus · Accepted solution]

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,

[vvissamsetty]

Thanks Thableaus, that helped!

Cheers