topic Data modelling - Contracts in App Development https://community.qlik.com/t5/App-Development/Data-modelling-Contracts/m-p/1071668#M17518 <HTML><HEAD></HEAD><BODY><P>Hi we have a contract database having the following relationsship.</P><P></P><P><STRONG>ContractLines (The lines contains either of BrandID, QualityID or ItemID)</STRONG></P><P>ContractID</P><P>ContractLine</P><P>Contract.BrandID</P><P>Contract.QualityID</P><P>Contract.ItemID</P><P>Volume</P><P></P><P><STRONG>ProductTables</STRONG></P><P>BrandTable</P><P>BrandID</P><P>BrandPrice</P><P>BrandName</P><P></P><P><STRONG>QualityTable</STRONG></P><P>QualityID</P><P>QualityPrice</P><P>QualityName</P><P>BrandID</P><P></P><P><STRONG>ItemTable</STRONG></P><P>ItemID</P><P>ItemPrice</P><P>Item Name</P><P>QualityID</P><P></P><P>What I have difficulties in doing in QlikSense is to create a hierachy of the Products and then join that to the ContractLines, in order to on each Contract row display what Brand it belongs to and keeping the nice QlikSense relation to the product hierachy. Any tips?</P><P>My best guess is that I have to create a relation table e.g. ContractBrandID and BrandID inbetween ContractLines and BrandTable and so on? And then to create the realation between the Product tables where all product data is joined into one table and finally link that to the perviously created relationship tables between Contractlines and BrandID etc?</P><P></P><P>Kr</P><P>Anders</P></BODY></HTML> Mon, 08 Feb 2016 13:11:45 GMT 2016-02-08T13:11:45Z Data modelling - Contracts https://community.qlik.com/t5/App-Development/Data-modelling-Contracts/m-p/1071668#M17518 <HTML><HEAD></HEAD><BODY><P>Hi we have a contract database having the following relationsship.</P><P></P><P><STRONG>ContractLines (The lines contains either of BrandID, QualityID or ItemID)</STRONG></P><P>ContractID</P><P>ContractLine</P><P>Contract.BrandID</P><P>Contract.QualityID</P><P>Contract.ItemID</P><P>Volume</P><P></P><P><STRONG>ProductTables</STRONG></P><P>BrandTable</P><P>BrandID</P><P>BrandPrice</P><P>BrandName</P><P></P><P><STRONG>QualityTable</STRONG></P><P>QualityID</P><P>QualityPrice</P><P>QualityName</P><P>BrandID</P><P></P><P><STRONG>ItemTable</STRONG></P><P>ItemID</P><P>ItemPrice</P><P>Item Name</P><P>QualityID</P><P></P><P>What I have difficulties in doing in QlikSense is to create a hierachy of the Products and then join that to the ContractLines, in order to on each Contract row display what Brand it belongs to and keeping the nice QlikSense relation to the product hierachy. Any tips?</P><P>My best guess is that I have to create a relation table e.g. ContractBrandID and BrandID inbetween ContractLines and BrandTable and so on? And then to create the realation between the Product tables where all product data is joined into one table and finally link that to the perviously created relationship tables between Contractlines and BrandID etc?</P><P></P><P>Kr</P><P>Anders</P></BODY></HTML> Mon, 08 Feb 2016 13:11:45 GMT https://community.qlik.com/t5/App-Development/Data-modelling-Contracts/m-p/1071668#M17518 2016-02-08T13:11:45Z