Hi we have a contract database having the following relationsship.
ContractLines (The lines contains either of BrandID, QualityID or ItemID)
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?