This content has been marked as final. Show 3 replies
I have two groups of students and their sporting interests.
If I select a value from School A, I serve up their interests. In this case, Bob is interested in 4 sports. Bob matches to many students on anywhere from 1 to 4 sports.
In School B, it turns out that Bob has 6 matches from the other school (they match on one of Bob's sports) and their sports interests include 10 sports.
Q: How can I limit the rows in the second object based on matching to to A_Sport? This way, I can ask Bob what sports he's REALLY interested in and serve up the corresponding matching students
I am keeping the variable names as A_Sport and B_Sport to prevent loops in the data model
I've tried =if(match and other expresions and am having no luck
Right now I can sort Bob's sports to the top of the second list but I'm also including ALL the other sports from students at School B
Chart In Qlikview:
Chart or List in Qlikview: