Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i hope you can help me.
I have a problem with the HIERARCHY in Qlikview.
I have a slow changing table in Qlikview with a recursive Agent relation (please give a look to the attached .xls).
I have to display the agents hierarchy in Qlikview with respect to the time information.
I tried to use the HIERARCHY LOAD but I do not know how to solve with respect to the time information.
What could be the right approach here?
Thanks for the hints,
Patric
Hi Gysbert,
i found the solution on my problem.
So I just wanted to share how I approached the problem:
In this way I have always the right snapshot of the hierarchy in a given time period.
You can find my app as attachment
Regards,
Patric
See attached example.
Hi,
first of all thanks for your answer.
I checked your attached .qvw file and I the problem which I also encountered in my solution is that the records in the table with the whole hierarchy are always duplicated. See my attached .qvw with the selected agentID 10000082.
If you apply a time filter, e.g. Year 2015 AND Month Feb, in the hierarchy table only one record should be displayed.
In that period the supervisor of 10000082 were 11000000 only, not 1000000 too !
Regards,
Patric
Hi Gysbert,
i found the solution on my problem.
So I just wanted to share how I approached the problem:
In this way I have always the right snapshot of the hierarchy in a given time period.
You can find my app as attachment
Regards,
Patric