https://community.qlik.com/t5/QlikView/Slowly-Changed-Dimension-having-trouble/m-p/1543613#M439638 <P>Dear All ,</P><P>&nbsp;</P><P>I am trying to implement SCD here but unable to get the validated figures. Please have a look on the attached data model and suggest the way out.</P><P><SPAN>Employee does not have the direct relationship with SalesOrderHeader table.</SPAN>SalesOrderHeader order is associated with SalesTerritotyHistory table with Territory_ID,also with SalesTerritory</P><P>Thank you in advance!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SCD.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5849i32085AE0C01BA409/image-size/medium?v=v2&amp;px=400" role="button" title="SCD.PNG" alt="SCD.PNG" /></span></P> Wed, 13 Feb 2019 13:16:33 GMT nk16_ 2019-02-13T13:16:33Z https://community.qlik.com/t5/QlikView/Slowly-Changed-Dimension-having-trouble/m-p/1543613#M439638 <P>Dear All ,</P><P>&nbsp;</P><P>I am trying to implement SCD here but unable to get the validated figures. Please have a look on the attached data model and suggest the way out.</P><P><SPAN>Employee does not have the direct relationship with SalesOrderHeader table.</SPAN>SalesOrderHeader order is associated with SalesTerritotyHistory table with Territory_ID,also with SalesTerritory</P><P>Thank you in advance!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SCD.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5849i32085AE0C01BA409/image-size/medium?v=v2&amp;px=400" role="button" title="SCD.PNG" alt="SCD.PNG" /></span></P> Wed, 13 Feb 2019 13:16:33 GMT https://community.qlik.com/t5/QlikView/Slowly-Changed-Dimension-having-trouble/m-p/1543613#M439638 nk16_ 2019-02-13T13:16:33Z