Two fields in the same table linked with another table.

[#1]

Hi there,

I was wondering how I could link two different fields of the same table to another table.

In my case, I have two tables: The table User, and the table UserHierarchy.

The table UserHierarchy contains the following fields: IdHierarchy, IdUser, IdUserChild. Both IdUser, IdUserChild refer to rows in the table "User".

Now, I would like to display in a chart the list of employees of a user, but I can't come up with a way to achieve this.

Could someone provide any help ?

Thank you very much

Julian

[#2]

Thank you, I created a new thread there : http://community.qlik.com/thread/29919