https://community.qlik.com/t5/App-Development/Data-Model-Issue/m-p/1825736#M67879 <P>Hi Guys,</P><P>&nbsp;</P><P>How do i get my fact table to be T_ReportTotalTasks and the other Location table to join it. Do i need to left Join the Location table to it or Create a key somehow?</P><P>The current way it is set the Task Rates are all Multiplied and incorrect.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jamiemcc_0-1627638959444.png" style="width: 551px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59481i0A50F248C236D09A/image-dimensions/551x508?v=v2" width="551" height="508" role="button" title="jamiemcc_0-1627638959444.png" alt="jamiemcc_0-1627638959444.png" /></span></P><P>Any solutions greatly appreciated.</P><P>&nbsp;</P><P>Regards,</P><P>Jamie</P> Fri, 30 Jul 2021 09:57:39 GMT jamiemcc 2021-07-30T09:57:39Z https://community.qlik.com/t5/App-Development/Data-Model-Issue/m-p/1825736#M67879 <P>Hi Guys,</P><P>&nbsp;</P><P>How do i get my fact table to be T_ReportTotalTasks and the other Location table to join it. Do i need to left Join the Location table to it or Create a key somehow?</P><P>The current way it is set the Task Rates are all Multiplied and incorrect.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jamiemcc_0-1627638959444.png" style="width: 551px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59481i0A50F248C236D09A/image-dimensions/551x508?v=v2" width="551" height="508" role="button" title="jamiemcc_0-1627638959444.png" alt="jamiemcc_0-1627638959444.png" /></span></P><P>Any solutions greatly appreciated.</P><P>&nbsp;</P><P>Regards,</P><P>Jamie</P> Fri, 30 Jul 2021 09:57:39 GMT https://community.qlik.com/t5/App-Development/Data-Model-Issue/m-p/1825736#M67879 jamiemcc 2021-07-30T09:57:39Z