When you create a set you create a boolean value for each mark in/out of the set. For example, all of the rows in the fruit set are "True" for fruit, but they are "False" for the veges set.
Therefore, your parameter needs to be of type boolean so that you can use it in a calculated field with the boolean results of your sets.
I've attached my revisions in this workbook on sheet two. Here are the steps I took:
1. redefine the parameter as type: Boolean with value True = Fruits and value False = Veges
2. Create a calculated field defined as :
[Breakdown] = [Fruits]
3. use the calculated field as as filter
Now when the user interacts with the parameter, when they choose Fruits they are technically filtering for "True" values, and when they choose veges they filter for "False" values.
Let me know if you have any questions, hope this helps!
Test_Liz.twbx 16.8 KB
Thanks for your help. Unfortunately, I can't open the workbook - I'm still using Tableau 9.2 (can't change it because that's the only one available on my work network).
Can you please 'copy' and 'paste' the entire formula in the body of your reply so I can try it.
Thanks a million,
sorry about the version mixup, that was my fault
Thanks Elizabeth, that was really helpful!
On the other hand, I'm wondering if I have more than 2 sets, how to go about it? In this case it was only 'Fruits' and 'Veges', so we could use the Boolean (True) or (False). What if we had a set containing Fruits, Veges, Crops, Food, etc. How do I go about the interactive filtering using parameters, please?
Thanks a million. I so much appreciate your help with this.
1 of 1 people found this helpful
let's see if you can open this version...built in 9.2 this time.
Directions for multiple groups:
1. Create a new field that identifies which group each row is in, in the example below I called it "Set" since it identified which set each item is in:
IF [Fruits] then "Fruit" ELSEif [Veges] then "Veges"
2. Next I created a new parameter of type String, and loaded the values for the "Set" field
3. Finally I created another calculated field that will test whether the parameter selection is = to the value of the "Set" field:
Now use this calculated field in the view as a filter:
Again the filter is a "True/False" result, but this time it is comparing whether the parameter choice is exactly the value of the new field you created. If it is True, then it will show the members of that field.
Let me know if you have further questions!
Elizabeth, you are an incredible genius! Thank you so much. It is working well. I am very very grateful. I didn't know you could have 2 versions of Tableau on the same machine.