topic How can I implement SCD w/ only 1 table as source? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450244#M701705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'll attach a sample excel file having records below,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 536px;"><TBODY><TR><TD class="xl63" height="20" width="115"><SPAN style="color: #ff0000;"><STRONG>Employee ID</STRONG></SPAN></TD><TD class="xl63" width="157"><SPAN style="color: #ff0000;"><STRONG>Employee Name</STRONG></SPAN></TD><TD class="xl63" width="74"><SPAN style="color: #ff0000;"><STRONG>Gender</STRONG></SPAN></TD><TD class="xl63" width="86"><SPAN style="color: #ff0000;"><STRONG>Status</STRONG></SPAN></TD><TD class="xl64" width="104"><SPAN style="color: #ff0000;"><STRONG>Date Hired</STRONG></SPAN></TD></TR><TR><TD height="20">E-2012-0001</TD><TD>Zac Efron</TD><TD>Male</TD><TD>Single</TD><TD align="right" class="xl65">1/14/2012</TD></TR><TR><TD height="20">E-2012-0002</TD><TD>Selena Gomez</TD><TD>Female</TD><TD>Single</TD><TD align="right" class="xl65">1/15/2012</TD></TR><TR><TD height="20">E-2012-0003</TD><TD>Channing Tatum</TD><TD>Male</TD><TD>Single</TD><TD align="right" class="xl65">2/15/2012</TD></TR><TR><TD height="20">E-2012-0004</TD><TD>Amanda Seigfred</TD><TD>Female</TD><TD>Single</TD><TD align="right" class="xl65">3/2/2012</TD></TR><TR><TD height="20">E-2012-0005</TD><TD>Beyonce Knowles</TD><TD>Female</TD><TD>Married</TD><TD align="right" class="xl65">3/3/2012</TD></TR><TR><TD height="20">E-2012-0006</TD><TD>JoJo</TD><TD>Female</TD><TD>Single</TD><TD align="right" class="xl65">3/5/2012</TD></TR><TR><TD height="20">E-2012-0007</TD><TD>Jesse McCartney</TD><TD>Male</TD><TD>Single</TD><TD align="right" class="xl65">4/2/2012</TD></TR><TR><TD height="20">E-2012-0008</TD><TD>Mariah Carey</TD><TD>Female</TD><TD>Married</TD><TD align="right" class="xl65">4/2/2012</TD></TR><TR><TD height="20">E-2012-0009</TD><TD>Brian McKnight</TD><TD>Male</TD><TD>Married</TD><TD align="right" class="xl65">4/2/2012</TD></TR></TBODY></TABLE><P></P><P>That is the only table, but how can I know, if one of the employees changes the STATUS from <SPAN style="color: #ff0000;"><STRONG>SINGLE </STRONG><SPAN style="color: #000000;">to </SPAN><STRONG>MARRIED</STRONG></SPAN>?</P><P>How can I track changes or apply the SLOWLY CHANGING DIMENSION?</P><P></P><P>Please help asap. I need this to track <SPAN style="text-decoration: underline; color: #ff6600;"><STRONG>as of dates</STRONG></SPAN> reports.</P><P></P><P>==================================================================</P><P>Say for example,</P><P></P><P>As of June 6, 2012 Zac Erfron is <STRONG>Single</STRONG>, but as of Aug 1, 2012 he's <STRONG>Married</STRONG>. reports like that!</P><P>==================================================================</P><P></P><P>Best Regards,</P><P>Bill</P></BODY></HTML> Fri, 28 Sep 2012 01:24:37 GMT 2012-09-28T01:24:37Z How can I implement SCD w/ only 1 table as source? https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450244#M701705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'll attach a sample excel file having records below,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 536px;"><TBODY><TR><TD class="xl63" height="20" width="115"><SPAN style="color: #ff0000;"><STRONG>Employee ID</STRONG></SPAN></TD><TD class="xl63" width="157"><SPAN style="color: #ff0000;"><STRONG>Employee Name</STRONG></SPAN></TD><TD class="xl63" width="74"><SPAN style="color: #ff0000;"><STRONG>Gender</STRONG></SPAN></TD><TD class="xl63" width="86"><SPAN style="color: #ff0000;"><STRONG>Status</STRONG></SPAN></TD><TD class="xl64" width="104"><SPAN style="color: #ff0000;"><STRONG>Date Hired</STRONG></SPAN></TD></TR><TR><TD height="20">E-2012-0001</TD><TD>Zac Efron</TD><TD>Male</TD><TD>Single</TD><TD align="right" class="xl65">1/14/2012</TD></TR><TR><TD height="20">E-2012-0002</TD><TD>Selena Gomez</TD><TD>Female</TD><TD>Single</TD><TD align="right" class="xl65">1/15/2012</TD></TR><TR><TD height="20">E-2012-0003</TD><TD>Channing Tatum</TD><TD>Male</TD><TD>Single</TD><TD align="right" class="xl65">2/15/2012</TD></TR><TR><TD height="20">E-2012-0004</TD><TD>Amanda Seigfred</TD><TD>Female</TD><TD>Single</TD><TD align="right" class="xl65">3/2/2012</TD></TR><TR><TD height="20">E-2012-0005</TD><TD>Beyonce Knowles</TD><TD>Female</TD><TD>Married</TD><TD align="right" class="xl65">3/3/2012</TD></TR><TR><TD height="20">E-2012-0006</TD><TD>JoJo</TD><TD>Female</TD><TD>Single</TD><TD align="right" class="xl65">3/5/2012</TD></TR><TR><TD height="20">E-2012-0007</TD><TD>Jesse McCartney</TD><TD>Male</TD><TD>Single</TD><TD align="right" class="xl65">4/2/2012</TD></TR><TR><TD height="20">E-2012-0008</TD><TD>Mariah Carey</TD><TD>Female</TD><TD>Married</TD><TD align="right" class="xl65">4/2/2012</TD></TR><TR><TD height="20">E-2012-0009</TD><TD>Brian McKnight</TD><TD>Male</TD><TD>Married</TD><TD align="right" class="xl65">4/2/2012</TD></TR></TBODY></TABLE><P></P><P>That is the only table, but how can I know, if one of the employees changes the STATUS from <SPAN style="color: #ff0000;"><STRONG>SINGLE </STRONG><SPAN style="color: #000000;">to </SPAN><STRONG>MARRIED</STRONG></SPAN>?</P><P>How can I track changes or apply the SLOWLY CHANGING DIMENSION?</P><P></P><P>Please help asap. I need this to track <SPAN style="text-decoration: underline; color: #ff6600;"><STRONG>as of dates</STRONG></SPAN> reports.</P><P></P><P>==================================================================</P><P>Say for example,</P><P></P><P>As of June 6, 2012 Zac Erfron is <STRONG>Single</STRONG>, but as of Aug 1, 2012 he's <STRONG>Married</STRONG>. reports like that!</P><P>==================================================================</P><P></P><P>Best Regards,</P><P>Bill</P></BODY></HTML> Fri, 28 Sep 2012 01:24:37 GMT https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450244#M701705 2012-09-28T01:24:37Z Re: How can I implement SCD w/ only 1 table as source? https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450245#M701706 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I checked your sample excel. There's no status date and no one listed there changes status.</P><P></P><P>you should included the date they change status.</P><P></P><P>then you can use intervalmatch() function.</P><P></P><P>See qlikview help on how to use the said function.</P><P></P><P>Regards,</P><P>Alex</P></BODY></HTML> Fri, 28 Sep 2012 01:42:42 GMT https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450245#M701706 2012-09-28T01:42:42Z Re: How can I implement SCD w/ only 1 table as source? https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450246#M701707 <HTML><HEAD></HEAD><BODY><P>Hi Alexis,</P><P></P><P>Is there a way to have that history on my own? Coz when we have to compare it to reality, changes happen w/o any record listing.</P><P></P><P>Anyway, I've got solution for that! Thanks for the help.</P></BODY></HTML> Fri, 28 Sep 2012 17:30:02 GMT https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450246#M701707 2012-09-28T17:30:02Z Re: How can I implement SCD w/ only 1 table as source? https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450247#M701708 <HTML><HEAD></HEAD><BODY><P>post the solution</P></BODY></HTML> Sun, 09 Dec 2012 13:27:39 GMT https://community.qlik.com/t5/QlikView/How-can-I-implement-SCD-w-only-1-table-as-source/m-p/450247#M701708 2012-12-09T13:27:39Z