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

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account