Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I' m trying to use the hierarchy function in qlikview but im not getting exactly what i want out off it.
As you can see in the picture i have a parent child relation and in my code i use the hierarchy().
In the EmpPathName listbox there are 2 childName missing in the tree and i don´t know why?
Is this enough info for you guys to help me on the way?
Hierarchy(Child,Parent,ParentName,Name,ChildName,EmpPathName,'/',Depth)
T:
NoConcatenate
LOAD
Parent,
Child,
ParentName,
ChildName
Resident v_tmp;
Might be easier to solve your issue with a small sample QVW that shows the issue.
Could you upload one (with your original data or mock up / scrambled data)?
Have you looked into the resident table created with the Hierarchy Load prefix and checked if these child names are related to a pathname that looks correct?
Hi,
please post an example application that demonstrates the issue.
thanks
regards
Marco
please share the sample data or the application ..so that it will be helpful for us to understand the issue
Hierarchy(Child,Parent,ParentName,Name,ChildName,EmpPathName,'/',Depth)
T:
NoConcatenate
LOAD
Parent,
Child,
ParentName,
ChildName
Resident v_tmp;