HOW MULTIPLE FILTERS BEHAVE
By default, all filters that we set in Tableau are computed independently. That
is, each filter accesses all rows in the data source without regard to other
filters.
In case there are 2 filters that are applied in a Viz the result will be the
intersection of both filters i.e., of all filter values
Like AND operation
Region Filter
Sales Filter
The Viz will have the records that match the combined results of
the Sales and Region Filter
HOW MULTIPLE FILTERS BEHAVE
Step 1: Let us start with the below mentioned view of State Vs Sales
HOW MULTIPLE FILTERS BEHAVE
Step 2: Right-click Region, Select Show Filter
HOW MULTIPLE FILTERS BEHAVE
Step 3: Region is added to the Filters shelf and
the Filter control is shown to the end user
HOW MULTIPLE FILTERS BEHAVE
Step 4: Right-click Sales, Select Show Filter
HOW MULTIPLE FILTERS BEHAVE
Step 5: SUM(Sales) is added to the Filters shelf and the
Filter control is shown to the end user
HOW MULTIPLE FILTERS BEHAVE
Step 6: Change the range of SUM(Sales) filter as shown in
the below view i.e., from 40K to 80K
HOW MULTIPLE FILTERS BEHAVE
Step 7: Select only South in the Region Filter
HOW MULTIPLE FILTERS BEHAVE
Step 8: Select Entire View
HOW MULTIPLE FILTERS BEHAVE
Step 9: This is the Final View with combined filtered results
of Region and Sales
HOW MULTIPLE FILTERS BEHAVE
Step 10: We can validate the Multiple Filters by applying the
filters separately in 2 worksheets and then checking
the common members
The States that are common in both filters result are
Virginia, North Carolina and Georgia and this matches the
combined filtered result of the previous view
