topic Dealing with Fixture Table in QlikView https://community.qlik.com/t5/QlikView/Dealing-with-Fixture-Table/m-p/259546#M1207933 <HTML><HEAD></HEAD><BODY><P>I am getting myself acquainted with QlikView. I have done all the tutorial. The next part I have been recommended to do is to create an app. As I love football, I thought I would do one on the World Cup. I suspect lots of people will be doing that as well![:)]</P><P>The issue comes with how best to design the data. I have a fixture table which has the following fields:-</P><UL><LI>Date &amp; Time</LI><LI>Venue</LI><LI>Team1</LI><LI>Team2</LI></UL><P>For the list of fixtures, countries will be in the Team1 field some times and in the Team2 field some times. That works ok if you want just a list of fixtures. But if I want to select a particular country, and show all their fixtures I want to be able to show the values in both fields Team1 and Team2. How is that done in QlikView?</P><P>OK?</P><P>Thanks</P><P>Andy</P></BODY></HTML> Thu, 27 May 2010 09:30:54 GMT 2010-05-27T09:30:54Z Dealing with Fixture Table https://community.qlik.com/t5/QlikView/Dealing-with-Fixture-Table/m-p/259546#M1207933 <HTML><HEAD></HEAD><BODY><P>I am getting myself acquainted with QlikView. I have done all the tutorial. The next part I have been recommended to do is to create an app. As I love football, I thought I would do one on the World Cup. I suspect lots of people will be doing that as well![:)]</P><P>The issue comes with how best to design the data. I have a fixture table which has the following fields:-</P><UL><LI>Date &amp; Time</LI><LI>Venue</LI><LI>Team1</LI><LI>Team2</LI></UL><P>For the list of fixtures, countries will be in the Team1 field some times and in the Team2 field some times. That works ok if you want just a list of fixtures. But if I want to select a particular country, and show all their fixtures I want to be able to show the values in both fields Team1 and Team2. How is that done in QlikView?</P><P>OK?</P><P>Thanks</P><P>Andy</P></BODY></HTML> Thu, 27 May 2010 09:30:54 GMT https://community.qlik.com/t5/QlikView/Dealing-with-Fixture-Table/m-p/259546#M1207933 2010-05-27T09:30:54Z