Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with columns with same data

I have an excel with a huge database of soccer games. The columns are: "date", "stadium", "local_team", "local_score", "away_score", "away_team".

The problem is that I can't create a list box or a search engine to work within the columns "local_team" and "away team" as they are two separate columns that contain the same data. Each row is a game and sometimes the team in the column "local_team" apperas too in the column"away_team".

The goal will beto choose the "team x" from a list and  show me  the team in both columns "home_team" and "away_team".

thanks

1 Reply
Not applicable
Author

Check this one....