The combination of ID+Sub_ID is the main key that I would like to use to identify this feature.
Each ID+Sub_ID has one due date and status, along with other static fields that I did not display here for the sake of simplicity. So this information gets repeated because there are multiple rows of ID+Sub_ID due to the Users and Roles.
Each ID+Sub_ID has multiple Users and Roles associated with it and I need to display this information in a clean manner.
Right now, my solution is to break apart the data and make it all relational and multiple tables in Excel. Then, I import it into Qlik and have two tables. One table displays ID+Sub_ID and all the static information (Due Date, Status, etc.) so there are no repeating ID+Sub_IDs. The other table will strictly display User and Role. I would like to make the second table which displays Users and Roles blank unless the filter for a specific ID+Sub_ID is selected. If the filter is blank, I would like the table to be blank or display a message instructing the user to select a filter or filters. Otherwise, it will just be one large list of all the Roles and Users and wouldn't make sense.
My solution output is below.
Filter: ID+Sub_ID = 1A
ID
Sub_ID
Due Date
Status
1
A
2019-02-02
Current
User
Role
Person1
Supervisor
Person2
Analyst
Filter: (No Filter)
ID
Sub_ID
Due Date
Status
1
A
2019-02-02
Current
1
B
2019-03-15
Due
2
C
2019-10-20
Overdue
User
Role
Please select a filter to display data.
I am open to other ideas as well if anyone has a better solution.
