Discussion Board for collaboration on QlikView Scripting.
How do we set Qlik to load data in hierarchy. I have been getting error trying to load in that order
Hi, first try:
Still having problem mapping the fields i want in hierarcy together the form. The Hierarcy Parameter form is not very descriptive
Hi, I don't understand what kind of hierarchy you are searching, the hierarchy makes relations between a node ID and his parent, ie:
LOAD * INLINE [
200002,200, account 200002
Hierarchy (account, parent, name, 'Parent name', name, 'Path', '#', 'Level')
LOAD account, parent, name Resident orig;
DROP table orig;
Try the script and check the results...
Parameter 1 is the id of the record
Parameter 2 is the parent
Parameter 3 is the name of the node
Parameters 4,6 and 8 are strings Qv uses to name the fields.
Parameter 5 is the field QV uses to build the path.
Parameter 7 is the character QV uses as separator when creating paths
Hope this helps!