-
1. Re: selecting multiple values in parameter
Jonathan DrummeyNov 6, 2014 6:29 AM (in response to leo dec)
4 of 4 people found this helpfulTableau 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
-
2. Re: selecting multiple values in parameter
Steve Martin Nov 6, 2014 6:58 AM (in response to Jonathan Drummey)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
-
3. Re: selecting multiple values in parameter
leo dec Nov 6, 2014 7:03 AM (in response to Steve Martin)Hi Steve
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.
regards
-
4. Re: selecting multiple values in parameter
leo dec Nov 6, 2014 7:15 AM (in response to Jonathan Drummey)Hi Jonathan
thanks for quick reply.. could you please tell me how to create "Sales Range Filter " specified in the example given by you?
regards
-
5. Re: selecting multiple values in parameter
Jonathan DrummeyNov 6, 2014 7:29 AM (in response to leo dec)
1 of 1 people found this helpfulThere are instructions further down in that post.
-
6. Re: selecting multiple values in parameter
Ranadheer B Nov 6, 2014 8:49 AM (in response to Jonathan Drummey)2 of 2 people found this helpfulTableau 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.
-
7. Re: selecting multiple values in parameter
leo dec Nov 6, 2014 8:54 AM (in response to Ranadheer B)hi
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?
regards
-
8. Re: selecting multiple values in parameter
leo dec Nov 6, 2014 8:57 AM (in response to Jonathan Drummey)hi Jonathan
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
regards
-
9. Re: selecting multiple values in parameter
Steve Martin Nov 6, 2014 8:58 AM (in response to leo dec)1 of 1 people found this helpfulHi Leo,
- 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
Steve
-
10. Re: selecting multiple values in parameter
Jonathan DrummeyNov 6, 2014 9:44 AM (in response to leo dec)
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
-
11. Re: selecting multiple values in parameter
Seanna Miller Jul 10, 2015 9:45 AM (in response to leo dec)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)
-
12. Re: selecting multiple values in parameter
Pratik Bundela Jul 28, 2015 6:38 AM (in response to Seanna Miller)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
-
13. Re: selecting multiple values in parameter
Seanna Miller Jul 28, 2015 8:05 AM (in response to Pratik Bundela)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!
-
14. Re: selecting multiple values in parameter
Pratik Bundela Jul 28, 2015 8:13 AM (in response to Seanna Miller)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 <