Summing up direct reports in a hierarchy

Daniel_Moore — Fri, 06 Mar 2015 18:21:47 GMT

I'm working on an orgchart and I'm trying to add up the direct reports for each 'node' and all the "direct reports and below" for each node.

I've played around a bit with the script but no luck. Any ideas?

Testing:
HierarchyBelongsTo:
HierarchyBelongsTo(nodeAncestor, parentAncestor, NodeName, ParentId, AncestorName, DepthDiff)
Load
Node AS nodeAncestor,
Node AS NodeName,
ParentId AS parentAncestor
resident Nodes;

Re: Summing up direct reports in a hierarchy

Daniel_Moore — Mon, 09 Mar 2015 19:10:47 GMT

An idea from Qlikview - Hierarchy vs Hierarchy belongs to - YouTube Used hierarchy belongs to and created a table of 'managers' in the script so QlikView could count each occurrence.

Num:

LOAD * INLINE [

NumID,NumName,NumManagerID

1, George, 0

2, Sally,1

3, Frank,1

4, John,3

5, Mary,3

6, Errol,2

];

// Table with entries each time an EmployeeID occurs as a manager.

NoConcatenate

Count:

LOAD

NumManagerID as EmployeeID,

1 as MngrCount

Resident Num;

For directs and below I use made empFlag column for each employee and a straight table with: Sum (empFlag).

I've attached the sample - you can also use that sample as scratch when watching: Qlikview - Hierarchy vs Hierarchy belongs to - YouTube

topic Re: Summing up direct reports in a hierarchy in QlikView

Summing up direct reports in a hierarchy

Re: Summing up direct reports in a hierarchy