topic Self-referential database objects in QlikView https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176388#M44409 <HTML><HEAD></HEAD><BODY><P>The post title is a bit of a misnomer, but here we go.</P><P>There is an object in our database called Users. It has an ID, let's call it User_ID.</P><P>A User may refer someone else to use our application, thus creating a new user.</P><P>The actual referral is tracked in the system in a table most remarkably called 'User_Referral'. As far as this question is concerned, this table contains two user IDs, let's call them Referrer_ID and Referred_ID</P><P>My question is, how do I write a script that allows me to intelegently discuss 'Users' as an entire entity, as well as 'referrers' and those who were referred as distinct entities (bearing in mind that any given user may be either, neither or both)</P></BODY></HTML> Fri, 04 Sep 2009 23:19:06 GMT 2009-09-04T23:19:06Z Self-referential database objects https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176388#M44409 <HTML><HEAD></HEAD><BODY><P>The post title is a bit of a misnomer, but here we go.</P><P>There is an object in our database called Users. It has an ID, let's call it User_ID.</P><P>A User may refer someone else to use our application, thus creating a new user.</P><P>The actual referral is tracked in the system in a table most remarkably called 'User_Referral'. As far as this question is concerned, this table contains two user IDs, let's call them Referrer_ID and Referred_ID</P><P>My question is, how do I write a script that allows me to intelegently discuss 'Users' as an entire entity, as well as 'referrers' and those who were referred as distinct entities (bearing in mind that any given user may be either, neither or both)</P></BODY></HTML> Fri, 04 Sep 2009 23:19:06 GMT https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176388#M44409 2009-09-04T23:19:06Z Self-referential database objects https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176389#M44410 <HTML><HEAD></HEAD><BODY><P>I'm not sure if it's exactly what you need here, but you may want to look into a semantic load. Here's an example that tracks parent and child records.</P></BODY></HTML> Sat, 05 Sep 2009 05:07:56 GMT https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176389#M44410 johnw 2009-09-05T05:07:56Z Re: Self-referential database objects https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176390#M44411 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P><SPAN>its is a good example, but when <SPAN>i</SPAN> tried with another example it is not working.</SPAN></P></BODY></HTML> Wed, 22 Oct 2014 06:28:51 GMT https://community.qlik.com/t5/QlikView/Self-referential-database-objects/m-p/176390#M44411 2014-10-22T06:28:51Z