Loop in Table

[sumitratnani]

Hi Qliks,

I have following fields in a table.

Location_Id

Location_Name

Parent_Locaion_Id

Parent_Location_Id has Location_Id values. So there is loop.

End condition for loop is when Parent_Location_Id = Location_Id

e.g.

UserLocation:

Location _Id   Location_Name   Parent_Location_Id

BRI               Bristol                     UK

UK                United Kingdom       EUR

UR              Europe                    EUR

And UserTable:

UserID Location_ID

A          BRI

I want to write script or chart  expression to get entire address.

KIndly provide suggestions.

Thanks in advance.

[sunny_talwar · Accepted solution]

May be you need Hierarchy function easy and Efficient with example---