topic Loop in Table in QlikView https://community.qlik.com/t5/QlikView/Loop-in-Table/m-p/1320014#M409167 <HTML><HEAD></HEAD><BODY><P>Hi Qliks,</P><P>I have following fields in a table.</P><P></P><P>Location_Id</P><P>Location_Name</P><P>Parent_Locaion_Id</P><P></P><P>Parent_Location_Id has Location_Id values. So there is loop.</P><P>End condition for loop is when Parent_Location_Id = Location_Id</P><P>e.g.</P><P>UserLocation:</P><P>Location _Id&nbsp;&nbsp; Location_Name&nbsp;&nbsp; Parent_Location_Id</P><P></P><P>BRI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bristol&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UK</P><P>UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; United Kingdom&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EUR</P><P> UR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EUR</P><P></P><P></P><P></P><P>And UserTable:</P><P>UserID Location_ID</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BRI</P><P></P><P></P><P>I want to write script or chart&nbsp; expression to get entire address.</P><P></P><P>KIndly provide suggestions.</P><P>Thanks in advance.</P></BODY></HTML> Tue, 06 Jun 2017 14:59:02 GMT sumitratnani 2017-06-06T14:59:02Z Loop in Table https://community.qlik.com/t5/QlikView/Loop-in-Table/m-p/1320014#M409167 <HTML><HEAD></HEAD><BODY><P>Hi Qliks,</P><P>I have following fields in a table.</P><P></P><P>Location_Id</P><P>Location_Name</P><P>Parent_Locaion_Id</P><P></P><P>Parent_Location_Id has Location_Id values. So there is loop.</P><P>End condition for loop is when Parent_Location_Id = Location_Id</P><P>e.g.</P><P>UserLocation:</P><P>Location _Id&nbsp;&nbsp; Location_Name&nbsp;&nbsp; Parent_Location_Id</P><P></P><P>BRI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bristol&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UK</P><P>UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; United Kingdom&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EUR</P><P> UR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EUR</P><P></P><P></P><P></P><P>And UserTable:</P><P>UserID Location_ID</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BRI</P><P></P><P></P><P>I want to write script or chart&nbsp; expression to get entire address.</P><P></P><P>KIndly provide suggestions.</P><P>Thanks in advance.</P></BODY></HTML> Tue, 06 Jun 2017 14:59:02 GMT https://community.qlik.com/t5/QlikView/Loop-in-Table/m-p/1320014#M409167 sumitratnani 2017-06-06T14:59:02Z Re: Loop in Table https://community.qlik.com/t5/QlikView/Loop-in-Table/m-p/1320015#M409168 <HTML><HEAD></HEAD><BODY><P>May be you need <A href="https://community.qlik.com/docs/DOC-5490">Hierarchy function easy and Efficient with example---</A></P></BODY></HTML> Tue, 06 Jun 2017 15:22:51 GMT https://community.qlik.com/t5/QlikView/Loop-in-Table/m-p/1320015#M409168 sunny_talwar 2017-06-06T15:22:51Z