Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks
Check the Hierarchy() function.