Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Apr 22, 2019, 10:58 AM

Data and Filter from Different Database Views

Hi guys,

I have table in tableau like below (1st Database View) : 

Data and Filter from Different Database Views

 

and i have another table which is from another view (2nd Database View) :

pastedImage_2.png

One extra sub-Category in the above table is "Bed".

 

So i want to use the above table values as a filter in  Dashboard. Means Dashboard Views is from  (1st Database View) and Filters from (2nd Database View) :

 

Basically i want to see the "BED" extra sub-category in the filters.

 

pastedImage_8.png

 

Please help me out.

 

NOTE : Tableau workbook is attached.

 

Thanks,

Rank Issue.twbx
4 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Apr 22, 2019, 4:51 PM

    Hi Mudassar,

     

    You can just blend the data across the two data sources.

     

    In the workbook you attached:

    1. Go to sheet 9 and right click on the category filter.
    2. Select 'Apply to Worksheets' and 'Selected Worksheets'Hi Mudassar, You can just blend the data across the two data sources. In the workbook you attached:Go to sheet 9 and right click on the category filter.
    3. Select Sheet 8 (Sheet 9 is already selected since that is the sheet that you are adding filters from).pastedImage_4.png
    4. Repeat steps 3 and 4 for the Sub-Category filter.
    5. On the 'Filter Independent' dashboard, make sure the Sub-Category filter is set to 'Only Relevant Values'.pastedImage_5.png

     

    This will allow you to use filters from the desired data source:

    pastedImage_7.png

     

    I attached the workbook, but you may not be able to open it due to me using a newer version of tableau.

     

    Hope this helps!

    Travis

Write an answer...
0/9000