topic Dynamic Entity Relationship in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Entity-Relationship/m-p/424384#M158113 <HTML><HEAD></HEAD><BODY><P>Has anybody ever dealt with a data model where a parent group can have varying levels of children?&nbsp; I am having a hard time wrapping my head around developing a data model for an active directory, where a parent security group could have children that are users and/or children groups that might have more groups and/or users underneath them.&nbsp; I need to be able to score individual users and aggregate them up through the hierarchy in a way that is fluid.&nbsp;&nbsp; Here is a sample of the kind of relationship I am describing:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 299px;"><TBODY><TR><TD class="xl63" height="20" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 1</STRONG></SPAN></TD><TD class="xl63" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 2</STRONG></SPAN></TD><TD class="xl63" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 3</STRONG></SPAN></TD><TD class="xl63" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 4</STRONG></SPAN></TD></TR><TR><TD height="20">User A</TD><TD>User D</TD><TD>User G</TD><TD>User I</TD></TR><TR><TD height="20">User B</TD><TD>User E</TD><TD>User H</TD></TR><TR><TD height="20">User C</TD><TD>User F</TD></TR><TR><TD height="20">Group 2</TD><TD>Group 3</TD></TR><TR><TD>Group 4</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 08 Mar 2013 22:16:35 GMT Anonymous 2013-03-08T22:16:35Z Dynamic Entity Relationship https://community.qlik.com/t5/QlikView/Dynamic-Entity-Relationship/m-p/424384#M158113 <HTML><HEAD></HEAD><BODY><P>Has anybody ever dealt with a data model where a parent group can have varying levels of children?&nbsp; I am having a hard time wrapping my head around developing a data model for an active directory, where a parent security group could have children that are users and/or children groups that might have more groups and/or users underneath them.&nbsp; I need to be able to score individual users and aggregate them up through the hierarchy in a way that is fluid.&nbsp;&nbsp; Here is a sample of the kind of relationship I am describing:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 299px;"><TBODY><TR><TD class="xl63" height="20" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 1</STRONG></SPAN></TD><TD class="xl63" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 2</STRONG></SPAN></TD><TD class="xl63" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 3</STRONG></SPAN></TD><TD class="xl63" width="56"><SPAN style="text-decoration: underline;"><STRONG>Group 4</STRONG></SPAN></TD></TR><TR><TD height="20">User A</TD><TD>User D</TD><TD>User G</TD><TD>User I</TD></TR><TR><TD height="20">User B</TD><TD>User E</TD><TD>User H</TD></TR><TR><TD height="20">User C</TD><TD>User F</TD></TR><TR><TD height="20">Group 2</TD><TD>Group 3</TD></TR><TR><TD>Group 4</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 08 Mar 2013 22:16:35 GMT https://community.qlik.com/t5/QlikView/Dynamic-Entity-Relationship/m-p/424384#M158113 Anonymous 2013-03-08T22:16:35Z