topic Data Modelling Question in QlikView https://community.qlik.com/t5/QlikView/Data-Modelling-Question/m-p/285095#M105996 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>Authorizer should also be in fact table. Create the key of OrderNo and Authorizor in both table and then link it .</P></BODY></HTML> Wed, 18 Jan 2012 10:29:06 GMT vijay_iitkgp 2012-01-18T10:29:06Z Data Modelling Question https://community.qlik.com/t5/QlikView/Data-Modelling-Question/m-p/285094#M105995 <HTML><HEAD></HEAD><BODY><P>Hi - what is the best way to manage 1:M relationships in my data model. </P><P></P><P>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.</P><P></P><P>When i do a sum of Purchase Order Value across Authorizer the total value is doubled.&nbsp;&nbsp;&nbsp; Many Thanks Darrell.</P></BODY></HTML> Wed, 18 Jan 2012 09:45:32 GMT https://community.qlik.com/t5/QlikView/Data-Modelling-Question/m-p/285094#M105995 darrellbutler 2012-01-18T09:45:32Z Data Modelling Question https://community.qlik.com/t5/QlikView/Data-Modelling-Question/m-p/285095#M105996 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>Authorizer should also be in fact table. Create the key of OrderNo and Authorizor in both table and then link it .</P></BODY></HTML> Wed, 18 Jan 2012 10:29:06 GMT https://community.qlik.com/t5/QlikView/Data-Modelling-Question/m-p/285095#M105996 vijay_iitkgp 2012-01-18T10:29:06Z