Discussion Board for collaboration on QlikView Scripting.
working with SAP R/3
want to create an hierarchy (finance related) in order to create a structured balance sheet based on the tables:
SETNODE holds 2 relevant fields:
SETNAME = a parent node's name
SUBSETNAME = a node's name
the rules is:
if a SUBSETNAME value has no record where it is a SETNAME - then, it's a leaf, else - it's a node and it has SUBSETNAME values where it is a SETNAME
SETLEAF holds 3 relevant fields:
SETNAME = the leaf's name
VALFROM and VALTO = boundries for the range of data for that leaf
using the hierarchy(NodeID, ParentNodeID,...) function didn't seem to work, or maybe i didn't use it properly?
Go to Solution.
Thanks a lot!
the perfect answer to my issue