-
1. Re: Only Relevant Values in Tableau
Ombir Rathee Dec 3, 2018 11:04 PM (in response to koushik.neelakantha) -
2. Re: Only Relevant Values in Tableau
koushik.neelakantha Dec 3, 2018 11:41 PM (in response to Ombir Rathee)Hi Ombir, its not working when i try to select Use all values for subcat and manufacturer. Facing the same issue.
My requirement is my filters should be "only relevant values" and i should not show "All" and my all filters should work.
Regards,
Koushik.Mahfooj Khan
-
3. Re: Only Relevant Values in Tableau
Ombir Rathee Dec 3, 2018 11:45 PM (in response to koushik.neelakantha)-
Relevant Values_v10.3.twbx 1.2 MB
-
-
4. Re: Only Relevant Values in Tableau
Himanshu Goyal Dec 3, 2018 11:52 PM (in response to koushik.neelakantha)Hi Neelakantha,
Please find attach the workbook. Hope this helps.
Thanks,
Himanshu Goyal
-
Relevant Values.twbx 1.2 MB
-
-
5. Re: Only Relevant Values in Tableau
koushik.neelakantha Dec 3, 2018 11:59 PM (in response to Ombir Rathee)Hi, this is not working?
for example: I have selected office supplies,Art and Avery. when i go back to category and select Furniture, My subcategory and manufacturer filter automatically should show furniture subcat & manufacturer values but filters are showing No items .
Regards,
Koushik.
-
6. Re: Only Relevant Values in Tableau
Mahfooj Khan Dec 4, 2018 12:00 AM (in response to koushik.neelakantha)Hi,
How about this? Its good to avoid the dimension filters and use dashboard action filters which is more efficient.
Mahfooj
-
Relevant Values_v10.5.twbx 174.1 KB
-
-
7. Re: Only Relevant Values in Tableau
koushik.neelakantha Dec 4, 2018 12:00 AM (in response to Himanshu Goyal)Hi Himanshu can u send the file in 10.4 version please?
Regards,
Koushik.
-
8. Re: Only Relevant Values in Tableau
koushik.neelakantha Dec 4, 2018 12:48 AM (in response to Mahfooj Khan)Mahfooj, I need to show filters in dashboard as a quick filters can i do the same in ur approach. could u pls send the workbook in 10.4 version
Regards,
Koushik.Mahfooj Khan
-
9. Re: Only Relevant Values in Tableau
Amit Narkar Dec 4, 2018 12:03 AM (in response to koushik.neelakantha)could could try with all values in hierarchy instead of only relevant values. This option is available in 2018+
-
10. Re: Only Relevant Values in Tableau
koushik.neelakantha Dec 4, 2018 12:48 AM (in response to Amit Narkar)I need to show relevant values and i am using 10.4 version
-
11. Re: Only Relevant Values in Tableau
Mahfooj Khan Dec 4, 2018 1:55 AM (in response to koushik.neelakantha)I don't think its possible with all your conditions . You've to show "All" and before selecting different category you've to clear the filters from Sub-cat and Manufacturer quick filters. Or best way action filters though you need to think how and where to put these items in your view. It will occupy some additional real estate of your dashboard but it will be very efficient for sure. You can try this.
-
12. Re: Only Relevant Values in Tableau
koushik.neelakantha Dec 4, 2018 1:59 AM (in response to koushik.neelakantha)Hi Mahfooj, Could you please send a workbook with action filters(Version 10.4)? and can we use those filters as a quick filters without using ALL?
Regards,
Koushik
-
13. Re: Only Relevant Values in Tableau
Ombir Rathee Dec 4, 2018 2:23 AM (in response to koushik.neelakantha)Okay got it. Here is a workaround. Follow below steps.
1. Add the Category filter to Context.
2. Right click Subcategory Filter and Select All values in the context.
3. Right click Manufacturer filter and Select Only relevant values.
-
Relevant Values_v10.4.twbx 1.2 MB
-
-
14. Re: Only Relevant Values in Tableau
Mahfooj Khan Dec 4, 2018 2:41 AM (in response to koushik.neelakantha)Here you go!
-
Relevant Values_v10.4.twbx 2.4 MB
-