Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ridha_moosa
Contributor
Contributor

One to Many relationship from a single table

Hi Qlik Sense users

 

I have a single table with users - called "Users". In that table, there's a user.id (eg. 7988) and each user has a parent.id which is the user id of that parent.

 

Eg.

Charles Smith ; user.id = 9999 ; parent.id = 1000

Joe Done ; user.id = 1000; parent.id = 1

So essentially Joe is Charles's parent. And Joe will have many children underneath him.

 

I know how to clean this in Python/SQL but I've directly connected to PostgreSQL... But using only Qlik Sense, How would I get only the parent's id's and the corresponding names? and how will I get it to filter out by parent?

 

ThanksCapture.PNG

1 Reply
jwjackso
Specialist III
Specialist III

Check the Hierarchy() function.