Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nickmarlborough
Contributor III
Contributor III

Select only the values when...

Hi, 

I have a link table which essentially looks like this:

ID Name Responsibility
123 nick captain
123 oliver vice captain
1456 nick team member
1456 oliver captain
1456 sarah team member

 

and there are associations in the load editor based on the name and the ID.

I have a table in the dash that shows all the captains and vice captains as so...

name responsibility (do not show if team member) city email
nick captain x x
oliver vice captain x x
oliver captain x x

 

right now if were to select oliver, sarah would also come into scope given she sits in the same team (ID)... how do i make it so when i select a name, for example oliver, only the teams Oliver is vice captain for comes into scope.

Labels (1)
2 Replies
Gabbar
Specialist
Specialist

Unable to understand the problem here 
but if you select Oliver there will be two rows one of oliver captain and another of oliver being vice captain, no row containing sarah would come.

JonnyPoole
Employee
Employee

This post sounds like another post from earlier in the week.   It sounds like there is more to the data model than shown as selecting 'Oliver' should not show 'Sarah' based on the link table alone. You must have Sarah's name in another table that is linked by ID which means, any selection on the name (Oliver for example) is associating to other team members. 

To filter based on name & responsibility at the same time (based on one click) you would need to create a 'calculated dimension' in the table that displays a concatenated value that preserves both parts of the context you want to filter on (name and responsibility) into a single field for the user to click 

[name] & '-' & [responsibility] 

When the user selects this value  (ie  Oliver-Vice Captain) it filters for rows where name=oliver and responsibility=vice captain at the same time. 

If you don't produce this combined value , you would have to make 2 selections, one on name, and then a 2nd on responsibility to get it to filter to the same context.