topic Hierarchy and Slowly Changing Dimensions in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746149#M662298 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem with organization hierarchy.</P><P>Organization table is joined to link table with interval match (this link is working OK)</P><P></P><P><IMG alt="problem.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77151_problem.png" style="height: 364px; width: 620px;" /></P><P></P><P>main problem is that in d_organization table I have multiple rows with same ID</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Organization_id<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">scd_start_date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">scd_end_date</TH></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Name 1</TD><TD style="padding: 2px;">01.01.2012</TD><TD style="padding: 2px;">10.12.2012</TD></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Name 1</TD><TD style="padding: 2px;">11.12.2012</TD><TD style="padding: 2px;">31.12.2014</TD></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Name 2</TD><TD style="padding: 2px;">01.01.2015</TD><TD style="padding: 2px;">31.12.9999</TD></TR></TBODY></TABLE><P></P><P>How can I create Hierarchy with hierarchy()-funktion so that it's working properly with slowly changing dimensios?</P><P>At the moment Name 1 and Name 2 are both always active</P><P></P><P>cheers,</P><P>Tommi</P></BODY></HTML> Thu, 05 Feb 2015 07:35:44 GMT 2015-02-05T07:35:44Z Hierarchy and Slowly Changing Dimensions https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746149#M662298 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem with organization hierarchy.</P><P>Organization table is joined to link table with interval match (this link is working OK)</P><P></P><P><IMG alt="problem.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77151_problem.png" style="height: 364px; width: 620px;" /></P><P></P><P>main problem is that in d_organization table I have multiple rows with same ID</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Organization_id<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">scd_start_date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">scd_end_date</TH></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Name 1</TD><TD style="padding: 2px;">01.01.2012</TD><TD style="padding: 2px;">10.12.2012</TD></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Name 1</TD><TD style="padding: 2px;">11.12.2012</TD><TD style="padding: 2px;">31.12.2014</TD></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">Name 2</TD><TD style="padding: 2px;">01.01.2015</TD><TD style="padding: 2px;">31.12.9999</TD></TR></TBODY></TABLE><P></P><P>How can I create Hierarchy with hierarchy()-funktion so that it's working properly with slowly changing dimensios?</P><P>At the moment Name 1 and Name 2 are both always active</P><P></P><P>cheers,</P><P>Tommi</P></BODY></HTML> Thu, 05 Feb 2015 07:35:44 GMT https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746149#M662298 2015-02-05T07:35:44Z Re: Hierarchy and Slowly Changing Dimensions https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746150#M662300 <HTML><HEAD></HEAD><BODY><P>Did you select a date? Otherwise, how should Qlikview know which organisation records should be shown?</P></BODY></HTML> Thu, 05 Feb 2015 14:10:47 GMT https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746150#M662300 Gysbert_Wassenaar 2015-02-05T14:10:47Z Re: Hierarchy and Slowly Changing Dimensions https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746151#M662301 <HTML><HEAD></HEAD><BODY><P>Yes, I have selected a date</P></BODY></HTML> Thu, 05 Feb 2015 14:15:28 GMT https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746151#M662301 2015-02-05T14:15:28Z Re: Hierarchy and Slowly Changing Dimensions https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746152#M662303 <HTML><HEAD></HEAD><BODY><P>Can you post a qlikview document that demonstrates the problem? Read this document if you're worried about confidential information: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Thu, 05 Feb 2015 14:30:47 GMT https://community.qlik.com/t5/QlikView/Hierarchy-and-Slowly-Changing-Dimensions/m-p/746152#M662303 Gysbert_Wassenaar 2015-02-05T14:30:47Z