3 Replies Latest reply on Nov 15, 2018 12:40 PM by Stephen Rizzo

swapping sheets based on parameter does not show filters in hierarchical data

Fisseha Berhane Nov 15, 2018 9:06 AM

I have attached a sample notebook with the sample superstore data. I want to swap views based on time filter parameter. It consists of Month and Year. Further, I want the State and City dimensions to be added to the filter. I want the city filter to show only the cities in a selected state. Therefore, I have chosen "Only Relevant Values".

My issue:

When I change the time filter to Month, the city filter does not show any item. I see "No Items". Can you help me understand what is happening and how to solve it?

NB. If I do not make the city filter to show only 'Relevant Values', I do not have the 'No Items' problems but it shows cities that are not in the selected state as well.

relevant_filters.twbx 2.5 MB

1. Re: swapping sheets based on parameter does not show filters in hierarchical data

Stephen Rizzo Nov 15, 2018 10:21 AM (in response to Fisseha Berhane)
Tableau links each filter to a worksheet. If the worksheet associated with the [City] filter is hidden, no values for that field are considered "relevant". The easy workaround is to use hierarchies or context filters to make the filters cascade. Specifically, using context filters:

Add the [State] filter to context.
Set the [City] filter in your dashboard to use "All Values in Context"
Like Show 0 Likes(0)

Actions
2. Re: swapping sheets based on parameter does not show filters in hierarchical data

Fisseha Berhane Nov 15, 2018 12:32 PM (in response to Stephen Rizzo)

I added the [State] filter to context and set the [City] filter to 'All Values in Context" but still as you can see from the screenshot below, still there is 'No Items' when I change the Time filter to Month. Can you attach a working worksheet for me? thanks
Like Show 0 Likes(0)

Actions
3. Re: swapping sheets based on parameter does not show filters in hierarchical data

Stephen Rizzo Nov 15, 2018 12:40 PM (in response to Fisseha Berhane)
It works fine for me - see attached.

relevant_filters v2.twbx 2.4 MB
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

swapping sheets based on parameter does not show filters in hierarchical data

1. Re: swapping sheets based on parameter does not show filters in hierarchical data

2. Re: swapping sheets based on parameter does not show filters in hierarchical data

3. Re: swapping sheets based on parameter does not show filters in hierarchical data

Actions

More Like This