topic Re: Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots in Archived Groups https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866691#M2995 <HTML><HEAD></HEAD><BODY><P>Hi Daiana</P><P></P><P>as far i understand, stat date and end date don't mean the same in different tables</P><P>so break this link naming dates differently according table like plan_startdate, and staff_strat_date&nbsp; (as weel for end date)</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Thu, 28 May 2015 13:51:24 GMT 2015-05-28T13:51:24Z Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866689#M2993 <HTML><HEAD></HEAD><BODY><P>Hi everybody. I've been asked to develop an Academy model that includes:</P><P>1. A <STRONG>Plan sheet</STRONG> that tells which job requires which course to be done with a certain frecuency. This Plan has snapshots because it can change through time</P><P>2. A <STRONG>Staff db&nbsp; </STRONG>which tells you which person has which job. This Staff <SPAN style="font-size: 13.3333330154419px;">has snapshots because it can change through time.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">3. An <STRONG>Attendance sheet</STRONG> that tells you which person attended which course on what date.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">My problem is that I have two slowly changing dimensions type 2, and I got stuck in a circular reference from which I can't escape!</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Additionally, if I match the snapshots I get information thats not aaditive, case in which i can't calculate KPIs involving duration of courses. <BR /></SPAN></P><P></P><P>Any help?</P><P><IMG alt="2015-05-28_9-12-52.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87913_2015-05-28_9-12-52.png" style="height: auto;" /></P></BODY></HTML> Tue, 22 Jul 2025 17:59:49 GMT https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866689#M2993 Anonymous 2025-07-22T17:59:49Z Re: Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866690#M2994 <HTML><HEAD></HEAD><BODY><P>you has tried concatenate Attendance with PLan or Staff?</P></BODY></HTML> Thu, 28 May 2015 13:37:36 GMT https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866690#M2994 uroboros 2015-05-28T13:37:36Z Re: Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866691#M2995 <HTML><HEAD></HEAD><BODY><P>Hi Daiana</P><P></P><P>as far i understand, stat date and end date don't mean the same in different tables</P><P>so break this link naming dates differently according table like plan_startdate, and staff_strat_date&nbsp; (as weel for end date)</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Thu, 28 May 2015 13:51:24 GMT https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866691#M2995 2015-05-28T13:51:24Z Re: Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866692#M2996 <HTML><HEAD></HEAD><BODY><P>Start and End are not linked, this was a basic example. Staff and Plan Tables are linked by Field Job, Plan and Attendance by field Course and Attendance and Staff by field Person. Start and End are there so that i can interval match the right staff with the right plan.</P><P></P><P> </P><P></P><P>De: christianj </P><P>Enviado el: jueves, 28 de mayo de 2015 15:52</P><P>Para: Daiana Rossignol</P><P>Asunto: Re: - Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots</P><P></P><P> </P><P></P><P></P><P> </P><P></P><P> </P><P> &lt;https://community.qlik.com/resources/images/palette-1004/headerLogo-1391206184624-QlikCommunity_logo.gif&gt;</P></BODY></HTML> Thu, 28 May 2015 14:11:53 GMT https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866692#M2996 Anonymous 2015-05-28T14:11:53Z Re: Circular reference trap! Slowly Changing Dimension Type 2 and Snapshots https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866693#M2997 <HTML><HEAD></HEAD><BODY><P>Can you provide the qvw ?</P></BODY></HTML> Thu, 28 May 2015 14:17:09 GMT https://community.qlik.com/t5/Archived-Groups/Circular-reference-trap-Slowly-Changing-Dimension-Type-2-and/m-p/866693#M2997 2015-05-28T14:17:09Z