Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone have any good ideas on how to build a complete
ancestor/descendant hierarchy
Let me illustrate - below is the treestructure data:
NodeID ParentID
--------------------------
1 NULL
2 1
3 2
4 2
This is the output that i want from the ancestor query:
AncestorID DescendantID
-----------------------------------------
1 2
2 3
2 4
1 3
1 4
Any help on how to achieve this would be greatly appreciated.
Best regards
Aviad
The best way to learn it is studing the PRESIDENTS example that comes with the qlikkview complete instalation.
It comes in a easy to understand case and a well commented script!
Enjoy!