Paint Hierarchy in Qlik Sense

17/03/2019

Hierarchy in qlik sense: Parent_Child: LOAD EMPLOYEE_NUMBER, FULL_NAME_HEB,FULL_NAME_HEB as PATH1, MANAGER_NUMBER, MANAGER_FULL_NAME_HEB, TEAM_DESC, BussinesUnit resident t1; T2: //Hierarchy (NodeID, ParentID, NodeName, , , , , )(loadstatement Hierarchy(EMPLOYEE_NUMBER, MANAGER_NUMBER, , , ,PathName , '/' , /* TreeView*/) LOAD * Resident Parent_Child; ParentWithAllChilds: HierarchyBelongsTo ( EMPLOYEE_NUMBER, MANAGER_NUMBER, FULL_NAME_HEB, 'ParentId', 'ParentName' ) Load EMPLOYEE_NUMBER, MANAGER_NUMBER, FULL_NAME_HEB Resident T2; Qualify...
אין תגובות