4 Replies Latest reply on Aug 17, 2018 7:01 AM by Okechukwu Ossai

# Dynamic Sets Question

The attached workbook has a matrix that shows the number of members in each of 10 categories (gray). Also shown is the number of members in each intersection of categories (orange).

Thought I would experiment with dynamic sets to get the same values. The bar chart on the left uses Category Name Parameter 1 and is filtered by Set Category Name 1...no problem, I get the same values as in the gray.

However, when I try to use two parameter and a combined set to filter the data, I can't get the values in the orange...am I missing something?

Ben

• ###### 1. Re: Dynamic Sets Question

HI Ben,

I think below approach is much easier?

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Dynamic Sets Question

Thanks.

Do you have any Idea why the combined sets do not work?

Ben

• ###### 3. Re: Dynamic Sets Question

Hi Ben,

"Set" is kind of legacy concept and I usually do not use them at all.

Anyways, "filter" filters underlying data and if value is independent, there is no other value.

If the problem is solved, could you mark my answer as correct to close the thread, and mark "helpful' as a manner.

Not from inbox view but from originals pot.

Thanks,

Shin

• ###### 4. Re: Dynamic Sets Question

Oh the beauty of Tableau, this could be done in yet another approach.

The combined sets probably need more conditions in the set formula to make it work. However, you can easily achieve the desired result using an alternative approach.

Step 1: Create calculated field [Category Combination Filter]

IF [Category Name Selection 1] <> [Category Name Selection 2] THEN

{FIXED [Member ID]: SUM([Category Value])} > 1

ELSE

{FIXED [Member ID]: SUM([Category Value])} > 0

END

Add this to the filter shelf and set to 'True'

Step 2: Create calculated field [Category Name Filter]

[Category Name Selection 1] = [Category Name] OR [Category Name Selection 2] = [Category Name]

Add this to the filter shelf and set to 'True'. Then add the filter to context.

Hope this helps.

Ossai