topic pls help in QlikView

pls help

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Here is my script to create hierarchical data

Employees:

LOAD [Emp No.] as EmpID,

[Emp No.] as EmployeeName,

[Reporting Manager Emp ID] as [Reports To]

FROM

(biff, embedded labels, table is Sheet1$);

Hierarchy:

Hierarchy (EmpID, ManagerID, EmpName, Manager, EmpName, EmpHierarchy, '/', Depth)

LOAD EmpID,

EmployeeName as EmpName,

[Reports To] as ManagerID

Resident Employees;

Now am using D3 Tree Layout extention to create Org chart

In the list box, if I select EmpID then it is not showing corresponding hierarical data.

PFA for your reference.

I have tried with below script

Hierarchybelongsto:

HierarchyBelongsTo(EmpID, ManagerID, EmpName, ManagerID, AncestorName, DepthDiff)

LOAD EmpID,

EmployeeName as EmpName,

[Reports To] as ManagerID

Resident Employees;

Any ideas will be appreciated.

Re: pls help

kaushiknsolanki — Wed, 28 Jun 2017 11:02:22 GMT

Kindly share the application and also the extension.

Regards,

Kaushik Solanki