topic Re: leader hierarchy - set analysis in App Development

leader hierarchy - set analysis

Qlikuser09 — Tue, 08 Nov 2022 15:45:10 GMT

I have Employees table with employee name , leaders name and leader level relation mentioned as level 1 ,2 , 3 , 4 ,5, 6.

some times the leader be level 6 to a employee and some times , he may be level 3 to a employee, is there a way to have a leader name mention only once under a hierarchy chart. when i create a chart the leader name is duplicated since he is in two location(level 6 and level 3)

Re: leader hierarchy - set analysis

rubenmarin — Tue, 08 Nov 2022 16:13:20 GMT

Hi, can you post some sample data and the expected result?

Re: leader hierarchy - set analysis

Qlikuser09 — Tue, 08 Nov 2022 17:06:06 GMT

Employee name	leader name	Employee number	Leader employee number	leader relation level
James	John	12345	19876	6
jacob	John	13452	19876	4
francis	John	15647	19876	6
Liam	John	23452	19876	2
Kassie	John	34562	19876	6
klaudia	mary	19087	10675	5
marie	mary	67895	10675	5
ales	mary	34567	10675	3

Here consider John is the CEO and mary next level to john

expected output:

with the leader "John" being the top followed by mary and the employees below her represented in pivot view

Is there a way i could group by leader name or employee id ??

Re: leader hierarchy - set analysis

rubenmarin — Wed, 09 Nov 2022 07:27:34 GMT

But what is the real expected output from this data? like this?: