0 Replies Latest reply: Feb 8, 2016 8:11 AM by Anders Jungbeck RSS

    Data modelling - Contracts

      Hi we have a contract database having the following relationsship.

       

      ContractLines (The lines contains either of BrandID, QualityID or ItemID)

      ContractID

      ContractLine

      Contract.BrandID

      Contract.QualityID

      Contract.ItemID

      Volume

       

      ProductTables

      BrandTable

      BrandID

      BrandPrice

      BrandName

       

      QualityTable

      QualityID

      QualityPrice

      QualityName

      BrandID

       

      ItemTable

      ItemID

      ItemPrice

      Item Name

      QualityID

       

      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?

      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?

       

      Kr

      Anders