Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
So I have the following tables:
What I have done is to first use the Qlikview hierarchy function to create the staff hierarchy. After which I used interval match to match the dates the activities occur to try to find who the employee was reporting to during that particular date. Do note that the employee-boss hierarchy changes for different periods (as mentioned above).
Issue: I'm getting loops in my data structure as follows:
Any ideas on how I can solve the loop?
So I've solved it by first creating a composite key of ID & Date in the Activities table, then creating a temporary bridge table, after which creating a new bridge table of All the dates joined into one interval.
Hi New_Qliker,
Try the following :
1)Link Employees EMP_ID with StaffHierarchy EMP_ID
Also, In StaffHIerarchy, load EMP_ID as empID(just an alias for a diff column name to get rid of that synthetic Key)
2) Rename Activities EMP_ID as empID.
This should work.You dont need a bridge table in this case,as you have only one fact.
Hope this helps.
Please get back to me with your result or any further queries.
Rochelle