Forum Discussion

JoseDavidM's avatar
JoseDavidM
Helper I
5 years ago

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 ...
Need Help
HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

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's avatar
    JoseDavidM
    Helper I
    5 years ago

    Thank you for the answer, i am getting an error: "The Cardinality that you have selected is not valid for this relation"

    • HashamNiaz's avatar
      HashamNiaz
      Solution Sage
      5 years ago

      Hi JoseDavidM !

      Table1 & Table2 doesn't hold unique [Code] values ?

      • JoseDavidM's avatar
        JoseDavidM
        Helper I
        5 years ago

        No, only table 3 have unique values (my mistake)