Hierachy in qlik sense

[ajaykumar1]

Hi All,

I need some help on the below requirement in Qlik sense. I tried with Hierarchy, but some gap.

Employee:

Manager ID	Emp Id	Manager Name	Emp Join date	Refresh Date	Remarks
50	101	Mexin	12-10-2013	13-12-2013
101	505	Martin	05-09-2015	10-09-2015
102	605	Alex	12-09-2016	15-10-2016
103	405	Anand	16-09-2016	16-10-2016
90	505	Jatin	05-09-2015	18-09-2017	505 employee changed manager from 101 to 90
101	700	Martin	18-09-2017	18-09-2017
101	710	Martin	10-09-2019	20-07-2020
30	101	Sukash	12-10-2013	24-07-2020	101 employee changed manager from 50 to 30

When I select my RefreshDate based on the emp details hierarchy need to show.

E.g. If I select refresh date 10-09-2015 then 505 emp id should have manager id as 101.

     If select 18-09-2017 then then 505 emp id should have manager id as 90

e.g. If I select refresh date 13-12-2013 then 101 emp id should have manager id as 50.

     If select 24-07-2020 then then 505 emp id should have manager id as 30

Regards,

Danu

[ajaykumar1]

Hi Kush,

I have applied my field name as you mentioned then getting the 0 records. Is it possible to share your app?

Also do we no need to use Hierarchy again? Earlier i used hierarchy to drill down and see the lowest level granularity.

Regards,

Danu

[Kushal_Chawda]

I don't see any use of hierarchy function here as it is more about dependent on refresh date. Please see the attached app.

[ajaykumar1]

Thanks Kush, but small gap is there.

e.g.  for emp id 101 the manager id is 50 upto 20-07-2020 ( where  manager id changed to 30 on 24-07-2020).

But we are getting only 1 on 13/12/2013. we have to get upto 20-07-2020.

Thank you so much for your help.

[Kushal_Chawda]

actually I had added some dummy data to test on multiple manager changes. That is why count will be different. You can try on your data and let me know if any gaps