topic Re: How to create hierarchy tree view in QlikView

How to create hierarchy tree view

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

Hi Guru's

How to create Hierarchy with the excel data.

below is the output format.

Thanks in advance

Thanks,

jason

Re: How to create hierarchy tree view

jwjackso — Tue, 06 Oct 2020 16:25:39 GMT

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];