Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

Hierachy in qlik sense

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

Labels (1)
13 Replies
ajaykumar1
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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