Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I don't see any use of hierarchy function here as it is more about dependent on refresh date. Please see the attached app.
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.
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