Forum Discussion

marial16's avatar
marial16
Helper II
3 years ago

Filter multiple tables based on Status not working

Hello,

 

i have the following case.

A table with 2 columns ID / Status has to filter 10 tables.

i would like to filter by status (1 = Active, 0=Inactive)

All those tables reffer to an employee.

There is another table named HR that has the Employee Name. All 10 tables have the Employee Name as a column.

 

HR is connected to all tables using employees Identification No.

I would like to select Status 1 from a slicer and filter All 10 tables

This is not working. It only works for 1 table.

Any help would be appreciated !

 

Need Help

3 Replies

    • marial16's avatar
      marial16
      Helper II
      3 years ago

      HR is connected to all tables since i need to get the employee Names

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        It seem as the HR table and Employee Tables are interconnected, so Status is connected with other tables with an inactive relationship. By default , inactive relationship is not active and thus will not pass the filtering. So comes the issue you have. 

         

        Inactive relationship could be temporally activated with USERELATIONSHIP, but considering the number of your tables, that would be a long code. 

         

        Let's see what good proposals others may come up with.