Forum Discussion
Several Sliders Filtering one table
Hi. i am trying to use the values selected in several sliders to filter one table. example.
Table 1
| Code | Name |
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 1 | A |
| 2 | B |
Table 2
| Code | Name |
| 5 | E |
| 6 | F |
| 7 | G |
| 5 | E |
| 6 | F |
Table 3
| Code | Name | Location |
| 1 | A | Location 1 |
| 2 | B | Location 1 |
| 3 | C | Location 2 |
| 5 | D | Location 2 |
| 6 | E | Location 2 |
| 7 | F | Location 2 |
I have created the Slider 1 with the field Table1.Code and Slider 2 with the Field Table2.Code and i need to filter the Table 3 using both values in slider 1 and 2, for example: if i selected in slider 1 = 2 and in Slider 2 = 3 i need that Table 3 only shows 2 and 3 Codes.
any idea?
9 Replies
- Ashish_Mathur
Super User
Hi,
I am quite confused. For your limited question/requirement, what is the use of Table1 and Table2. Just use Table3 to build your slicer and visual.
- JoseDavidM
Helper I
it maybe make more sense if a show the actual data
in the image below Slicer 1 is used to filter info in Slicer 2 that at the same time filter Slicer 3 an so on.
each value in each slicer contain more detail information that doesnt fit in this page, for that reason a create another page to provide the user with those details (see image below)
but i still have some issue trying to show all the data in one page, especially because the table doesnt clean up after a select new value on the page 1 slicers
i'm looking for a better way to show those details
this is my table and relations structure. tables above contain the general information and the relation beetwen each slicers in page 1 and tables below contain the details of each value selected
my issue is that if no value is selected in the slicers all values are shown on the detail page
- HashamNiaz
Solution Sage
Hi JoseDavidM !
Please share your data model diagram how you have connected these table through relationship.You can connect Table1 to Table3 using 1-Many relationship based on [Code] Column, also you need to connect Table2 to Table3 using 1-Many relationship based on [Code] Column.
Please check that filter direction is set to single. Hope this will solve your requirement.
Regards,Hasham
- JoseDavidM
Helper I
Thank you for the answer, i am getting an error: "The Cardinality that you have selected is not valid for this relation"
- HashamNiaz
Solution Sage
Hi JoseDavidM !
Table1 & Table2 doesn't hold unique [Code] values ?
- HashamNiaz
Solution Sage
Hi JoseDavidM !
Now with your modified requirement, you will need to create a new table Table 4 by merging Table 1 & Table 2.
You will need to connect Table 3 to Table 4 using 1-Many relationship based on [Code] Column, and set the cross filter direction to [Both].You can choose filter values from Table 4.
Hope this will help you solve the issue.
Regards,
Hasham