See both actual and opposite selection

[#1]

Two listboxes, home team and away team. If I select one home team and one away team I show results from previous games. But I also want the opposit, mid season the series turn around and all teams meet again but with reversed home and away.
How do I accomplish that in QlikView? I want to see the results for all games when the teams played. Possibly limited by a season selection, or not.
Rgds
Thomas

[swuehl · Accepted solution]

Maybe I am pretty off without knowing your data model, but maybe like this:

Use HomeTeam and AwayTeam as dimensions, then

=only({<HomeTeam= p(HomeTeam)+p(AwayTeam), AwayTeam=p(HomeTeam)+p(AwayTeam)>} Result)

I assume that you have only one Result per combination (one season selected).

Regards,

Stefan

[#3]

Thanks, Stefan! It kind of works... With teams that only have one season it works great. When there are more seasons it don't. I'll try to upload an exampel file during the day.

[swuehl]

Either use e.g. concat function instead of only() or add the event date or season as dimension.

[#5]

It works! Hade date as an expression. Now I have to figure out why/how it works...