topic Re: Help with columns with same data in QlikView https://community.qlik.com/t5/QlikView/Help-with-columns-with-same-data/m-p/425279#M567030 <HTML><HEAD></HEAD><BODY><P>Check this one....</P></BODY></HTML> Tue, 11 Dec 2012 13:25:57 GMT 2012-12-11T13:25:57Z Help with columns with same data https://community.qlik.com/t5/QlikView/Help-with-columns-with-same-data/m-p/425278#M567029 <HTML><HEAD></HEAD><BODY><P>I have an excel with a huge database of soccer games. The columns are: "date", "stadium", "local_team", "local_score", "away_score", "away_team".</P><P></P><P></P><P>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".</P><P></P><P></P><P>The goal will beto choose the "team x" from a list and&nbsp; show me&nbsp; the team in both columns "home_team" and "away_team". </P><P></P><P></P><P></P><P>thanks</P></BODY></HTML> Tue, 11 Dec 2012 12:29:54 GMT https://community.qlik.com/t5/QlikView/Help-with-columns-with-same-data/m-p/425278#M567029 Anonymous 2012-12-11T12:29:54Z Re: Help with columns with same data https://community.qlik.com/t5/QlikView/Help-with-columns-with-same-data/m-p/425279#M567030 <HTML><HEAD></HEAD><BODY><P>Check this one....</P></BODY></HTML> Tue, 11 Dec 2012 13:25:57 GMT https://community.qlik.com/t5/QlikView/Help-with-columns-with-same-data/m-p/425279#M567030 2012-12-11T13:25:57Z