Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Josn_Qlik356
Partner
Partner

How to create hierarchy tree view

Hi Guru's

 

How to create Hierarchy with the excel data.

 

below is the output format.

Josn_Qlik356_0-1601995545299.png

 

Thanks in advance

 

Thanks,

jason

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Look at the Hiearchy  function

Using the data below:

[Data]:
LOAD ProjectName,
TaskName,
TaskOutlineLevel,
TaskId,
ParentTaskId,
ProjectId,
TaskClientUniqueId,
ParentTaskName
FROM
[H:\Temp\test data.xlsx]
(ooxml, embedded labels, table is Sheet1);

[HierarchyTree]:
Hierarchy (TaskId,Parent,NodeName,'PathParent',NodeName,'TaskPath','/',Depth)
LOAD TaskId,
ParentTaskId as Parent,
TaskName as NodeName
Resident [Data];

hierarchy.PNG

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

Look at the Hiearchy  function

Using the data below:

[Data]:
LOAD ProjectName,
TaskName,
TaskOutlineLevel,
TaskId,
ParentTaskId,
ProjectId,
TaskClientUniqueId,
ParentTaskName
FROM
[H:\Temp\test data.xlsx]
(ooxml, embedded labels, table is Sheet1);

[HierarchyTree]:
Hierarchy (TaskId,Parent,NodeName,'PathParent',NodeName,'TaskPath','/',Depth)
LOAD TaskId,
ParentTaskId as Parent,
TaskName as NodeName
Resident [Data];

hierarchy.PNG

View solution in original post