3 Replies Latest reply on Sep 26, 2016 2:10 PM by Yunus Gittham

multiple filter based value swap -reopening issue with new thread as previous one was closed

Yunus Gittham Sep 26, 2016 1:45 PM

Hi All

Take a look at the attached.

The behavior should be

1. When All is selected on Product Name the worksheet should show strategy else it should show action.

2. For anything to show, there should be something selected in the sub-category filter. It cannot be empty.

Its not working.

Basically you have to select "All" on all the filters to show "Strategy" which is not the right behavior.

Can you please help?

1. Re: multiple filter based value swap -reopening issue with new thread as previous one was closed

Matt Hong Sep 26, 2016 1:59 PM (in response to Yunus Gittham)

This seems like the desired formula for SwitchValues:

IF SIZE() = [Count of Product Selected] then 'action plan'
else 'strategy' end

Let me know if that was what you were looking for.
Like Show 0 Likes(0)

Actions
2. Re: multiple filter based value swap -reopening issue with new thread as previous one was closed

Yunus Gittham Sep 26, 2016 2:06 PM (in response to Matt Hong)

Hi Matt

Looks like it may work. Will try it out.
Like Show 0 Likes(0)

Actions
3. Re: multiple filter based value swap -reopening issue with new thread as previous one was closed

Yunus Gittham Sep 26, 2016 2:10 PM (in response to Matt Hong)

Hi Matt

It does not work.

The selection for "Strategy" should be
Any one or more Category
Any one or more Sub Category
ALL Products

The selection for "Action" should be
Any one or more Category
Any one or more Sub Category
NOT ALL Products
Like Show 0 Likes(0)

Actions

Tableau Community