topic How to model multiple associations between tables in App Development https://community.qlik.com/t5/App-Development/How-to-model-multiple-associations-between-tables/m-p/1194521#M22512 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would think this question has been asked many times before, but I have looked for advice regarding modelling multiple associations between the same datasets, and haven't really found what I'm looking for.</P><P></P><P>A really simple example is the following. Assume I have a Person, with two addresses, a home address and a work address, both linking to an address table.</P><P>Person:</P><UL><LI>person_id</LI><LI>person_name</LI><LI>home_address_id</LI><LI>work_address_id</LI></UL><P></P><P>Address:</P><UL><LI>address_id</LI><LI>streetname</LI><LI>country_id</LI><LI>geolocation</LI><LI>...</LI></UL><P></P><P>How do I model this. There are basically two associations between the same tables. Most suggestions I have read somehow summarize as joining the two tables immediately, and copying some data from the address to the person. For example, joining so that you have:</P><UL><LI>person_id</LI><LI>person_name</LI><LI>home_street</LI><LI>work_street</LI><LI>...</LI></UL><P></P><P>That works if address is something I only need the streetname for, but in general that doesn't get me far. I want to follow associations to country and beyond if needed in my dashboards.</P><P></P><P>A more complex example of fundamentally the same issue is the following.</P><P></P><P>A project consists of multiple phases.</P><P>Project:</P><UL><LI>project_name</LI><LI>project_id</LI><LI>formal_kickoff_phase</LI></UL><P>Projectphase:</P><UL><LI>project_id</LI><LI>phase_name</LI></UL><P></P><P>Here two, there are multiple links: a project has many phases, and there is a specific link to one of those phases. Agreed that in this example, there could also have been a boolean "kickoff" in projectphase, but you don't always control the source datasets.</P><P></P><P>So my question is twofold:</P><P>1) How do I model multiple associations such as these in qliksense?</P><P>2) Are there any examples on how such multiple relations between two tables can be visualized? For example, how do you indicate which relation to follow when an element is selected?</P><P></P><P>Thanks in advance!</P><P>Regards,<BR />Yves</P></BODY></HTML> Wed, 26 Oct 2016 11:54:37 GMT 2016-10-26T11:54:37Z How to model multiple associations between tables https://community.qlik.com/t5/App-Development/How-to-model-multiple-associations-between-tables/m-p/1194521#M22512 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would think this question has been asked many times before, but I have looked for advice regarding modelling multiple associations between the same datasets, and haven't really found what I'm looking for.</P><P></P><P>A really simple example is the following. Assume I have a Person, with two addresses, a home address and a work address, both linking to an address table.</P><P>Person:</P><UL><LI>person_id</LI><LI>person_name</LI><LI>home_address_id</LI><LI>work_address_id</LI></UL><P></P><P>Address:</P><UL><LI>address_id</LI><LI>streetname</LI><LI>country_id</LI><LI>geolocation</LI><LI>...</LI></UL><P></P><P>How do I model this. There are basically two associations between the same tables. Most suggestions I have read somehow summarize as joining the two tables immediately, and copying some data from the address to the person. For example, joining so that you have:</P><UL><LI>person_id</LI><LI>person_name</LI><LI>home_street</LI><LI>work_street</LI><LI>...</LI></UL><P></P><P>That works if address is something I only need the streetname for, but in general that doesn't get me far. I want to follow associations to country and beyond if needed in my dashboards.</P><P></P><P>A more complex example of fundamentally the same issue is the following.</P><P></P><P>A project consists of multiple phases.</P><P>Project:</P><UL><LI>project_name</LI><LI>project_id</LI><LI>formal_kickoff_phase</LI></UL><P>Projectphase:</P><UL><LI>project_id</LI><LI>phase_name</LI></UL><P></P><P>Here two, there are multiple links: a project has many phases, and there is a specific link to one of those phases. Agreed that in this example, there could also have been a boolean "kickoff" in projectphase, but you don't always control the source datasets.</P><P></P><P>So my question is twofold:</P><P>1) How do I model multiple associations such as these in qliksense?</P><P>2) Are there any examples on how such multiple relations between two tables can be visualized? For example, how do you indicate which relation to follow when an element is selected?</P><P></P><P>Thanks in advance!</P><P>Regards,<BR />Yves</P></BODY></HTML> Wed, 26 Oct 2016 11:54:37 GMT https://community.qlik.com/t5/App-Development/How-to-model-multiple-associations-between-tables/m-p/1194521#M22512 2016-10-26T11:54:37Z Re: How to model multiple associations between tables https://community.qlik.com/t5/App-Development/How-to-model-multiple-associations-between-tables/m-p/1194522#M22513 <HTML><HEAD></HEAD><BODY><P>I too am having a problem with this. The simplest example is a trip that has an origin and a destination.</P><P></P><P>Airports:</P><UL><LI>airport_code</LI><LI>latitude</LI><LI>longitude</LI></UL><P></P><P>Flights_timetable:</P><UL><LI>airport_origin_code</LI><LI>airport_destination_code</LI><LI>etc...</LI></UL><P></P><P>Qlik Sense only agrees to associate the airport code with one of the fields - either the origin or the destination, but not both. How do I work around this, for example, to build an element that filters my flights on a graph by origin and destination?</P></BODY></HTML> Wed, 14 Jun 2017 17:58:28 GMT https://community.qlik.com/t5/App-Development/How-to-model-multiple-associations-between-tables/m-p/1194522#M22513 2017-06-14T17:58:28Z