Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

Tags (1)
Community Browser