This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need some help on the below requirement in Qlik sense. I tried with Hierarchy, but some gap.
Emp Join date
505 employee changed manager from 101 to 90
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
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.
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