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