Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
darrellbutler
Creator
Creator

Data Modelling Question

Hi - what is the best way to manage 1:M relationships in my data model.

For example I have a Purchase order value in my fact table, but in my Authorizers dimension table I have two records for the same purchase order as two people have authorized the spend.

When i do a sum of Purchase Order Value across Authorizer the total value is doubled.    Many Thanks Darrell.

1 Reply
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

Authorizer should also be in fact table. Create the key of OrderNo and Authorizor in both table and then link it .