This content has been marked as final. Show 2 replies
We are facing some issues when we are trying to use in a Qlik Sense app script hierarchies with Time dependency, using a slow change dimension.
Let me try to describe in few words the issue:
The goal is to allocate the consumed hours of each Employee to the appropriate organization unit based on fact transaction date (fact date between Position Start and position End Date)
and also to the organization Hierarchy structure (fact Date between Level Start and Level End Date) for each level.
There is a post ( https://community.qlikview.com/thread/190258) which I think mention the same case, the awnser of HIC was to combine the hierarchy resolution with model for a slowly changing dimension, we tried with no luck so far,
The allocation of hours doesn’t work correctly when there is a node with two possible parents, the example appears in application 2nd Sheet.