Discussion Board for collaboration on QlikView Scripting.
Here is a challenge for scripts experts concerning Hierarchy issue. To be as clear as possible, i attach an excel with my question. Thanks a lot guys for your answer.
please ? anyone could help me ?
Thanks a lot
Use the above script and
LOAD [HIERARCHY (Father)] as ParentID,
[HIERARCHY (Son)] as NodeID,
[HIERARCHY (Father)] as NodeName
(ooxml, embedded labels, table is Sheet1);
Hierarchy(NodeID, ParentID, NodeName)
NodeName1 as NodeID
drop table HIER;
Create a table box with NodeName1, NodeName2, NodeName3, NodeID to see the output