4 of 4 people found this helpful
Tableau doesn't currently support multi-valued parameters. One option is to set up a separate worksheet and a Filter Action, another workaround is to use a data blend http://drawingwithnumbers.artisart.org/creating-a-dynamic-parameter-with-a-tableau-data-blend/.
And another option would be to create a set and when adding it, switch from In/Out to Show Members and then show the quickfilter - though I suppose in the long-run this is not much different from a quickfilter, it just allows you to define the values of a set rather than exclude values from a quickfilter.
thanks for your quick reply.. is there any example so that i can see how it can be done.. i have just started learning tableau.
thanks for quick reply.. could you please tell me how to create "Sales Range Filter " specified in the example given by you?
1 of 1 people found this helpful
There are instructions further down in that post.
2 of 2 people found this helpful
Tableau doesnt have multiple selectiong option but you can add 'All' option parameter drop down.
Calculated field: if a=b then 'True'
elseif a='All' then 'True' end
put in filter and select True.
what i can understand from the solution provided by you is that user can select either 1 value or "All" option from the drop down... which means if user select 1 then it will show data for only 1 product and if user selects "All" then it will show multiple bars for all products...
tell me if my understanding is wrong?
are you talking about the below mentioned explanation... that formula is not for "Sales Range from Selected Customer" that is why i asked you how to create Sales Range Filter or Sales Range from Selected Customer to be used in "IF formula"
- Sales Range Filter – Used to filter the customer list based on the % difference, using a “Sales Range from Selected Customer” parameter.
- IF (ABS(SUM([Sales]) - [Sales for Selected])/[Sales for Selected]) <= [Sales Range from Selected Customer] THEN 1 END
1 of 1 people found this helpful
- To create the Set-based filter, simply drag your dimension to the filters shelf, the right-mouse select the filter pill and select Create Set...
- In this new dialogue (looks near identical to the filter dialogue and can be set-up in exactly the same way), set-up your filter for example if using Superstore Sales.Product Sub-Category and only wanting Appliances, Bookcases and Labels, de-select all other items bar those three, name your set and press ok
- Drag the set to the filters shelf
- If the filter displays as Set Name (In/Out) where Set Name is the name you applied in step 2, right-mouse select the pill on the filter shelf and select Show Members in Set.
- Right-Mouse select the pill and choose Show Quickfilter
- On the quickfilter options, convert to the filter of your choice choosing to show the Apply button for multiple options if you wish
Correct, that is the section I was referring to.
Sales Range for Selected Customer is a Parameter, which is defined in Tableau. For more instructions on how to create parameters, see http://kb.tableausoftware.com/articles/knowledgebase/using-parameters or read the documentation.
The Sales Range Filter calculated measure has the formula that you copied.
If you haven't yet downloaded the workbook for that, I suggest you do so and look at the Sales Range Workout worksheet, it shows the calculations in a crosstab that might make it easier for you to understand.
The problem with the set technique is that it assumes that you already know what selections your user will want to make as they are working through the data. What do you do when you don't know what these preselections would be? (e.g. today they want to pick A & B, but tomorrow they want to see B&C, the next day A&C, etc)
Hope your are doing great.
Is there a way to to club together the unselected filter items under a single name as "Others" and display this "Others" along with the selected items. I am using version 8.2.
Thanks a lot.
That sounds similar to the problem that I am trying to solve, in that you don't necessarily know what the users are going to want to group together. I did not receive any answer to my question - and I haven't found the answer yet myself. I will update if I discover a way to do this!
Even I am working over it.
Let's see who finds a turnaround first.
MS Business Analytics and Project Management
The University of Connecticut - School of Business
Phone : 860/313- 8895
On Tue, Jul 28, 2015 at 11:06 AM, Seanna Miller <