5 Replies Latest reply on Oct 6, 2018 5:49 PM by Joe Oppelt

2 tab sheet selector

Parag H Oct 4, 2018 11:42 PM

Hi,

I am facing a problem for selecting 2 sheets in tableau Dashboard. I have created a parameter and calculated field for the same but by default it select only one sheet and other sheet is not shown. At the same another tab of all gets added. In the same workbook I have created dashboard for selecting three sheets which is working fine but for two i am facing problem. I have also attached the snapshot of same for your reference.

Please let me know if any more information is required.

Another sheet selecter for 3 tabs working fine.png 255.5 KB
Meal Penetration tab not showing.png 249.4 KB

1. Re: 2 tab sheet selector

Sankarmagesh Rajan Oct 4, 2018 11:56 PM (in response to Parag H)

hi Parag

Attach workbook here.
check the filter added in view. type each value in each sheet in custom value list in filter.
Thanks
sankar
Like Show 1 Likes(1)

Actions
2. Re: 2 tab sheet selector

Parag H Oct 5, 2018 11:07 AM (in response to Sankarmagesh Rajan)
Please find the sheet attached herewith. Here M_operations in working fine while after applying same logic for M_category it is not working. I have kept both the things in sheet.

Thanks
Parag

View_by_test_f.twbx 51.8 KB
Like Show 0 Likes(0)

Actions
3. Re: 2 tab sheet selector

Joe Oppelt Oct 5, 2018 11:41 AM (in response to Parag H)

You didn't set your filter to a specific value on the Category sheet. You just have "Use All"
Like Show 1 Likes(1)

Actions
4. Re: 2 tab sheet selector

Parag H Oct 5, 2018 9:46 PM (in response to Joe Oppelt)

I have set filter for both sheet i.e. Meal and category. But as soon as i change the view to single value (list) filter automatically change. While for the other three sheets in same workbook is working fine.

Regards,
Parag
Like Show 0 Likes(0)

Actions
5. Re: 2 tab sheet selector

Joe Oppelt Oct 6, 2018 5:49 PM (in response to Parag H)
You had the filter for the two sheets set at "Apply to" each the two sheets.

You need them to be individual filters so that each can be set to different values.

I have done that in the copy uploaded here.

View_by_test_f_v10.4.twbx 37.1 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions