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/.

Jonathan

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.

Steve

There are instructions further down in that post.

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.

Hi Leo,

1. 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...
2. 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
3. Drag the set to the filters shelf
4. 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.
5. Right-Mouse select the pill and choose Show Quickfilter
6. On the quickfilter options, convert to the filter of your choice choosing to show the Apply button for multiple options if you wish

Steve

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.

Jonathan

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)

Hi Seanna,

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.

Best Regrads,

Pratik

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.

Best Regards,

Pratik Bundela

MS Business Analytics and Project Management

The University of Connecticut - School of Business

Phone : 860/313- 8895

<http://www.linkedin.com/in/pratikbundela/>

On Tue, Jul 28, 2015 at 11:06 AM, Seanna Miller <