17/03/2019
Paint Hierarchy in Qlik Sense
Hierarchy in qlik sense: Parent_Child: LOAD MANAGER_FULL_NAME_HEB, TEAM_DESC, BussinesUnit resident t1; T2: //Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement Hierarchy(EMPLOYEE_NUMBER, MANAGER_NUMBER, [FULL_NAME_HEB], [ParentName], [PathSource] ,PathName , '/' , [Depth]/* 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 *; ParentWithAllChilds1: load […]