Hierarchy where node is parent

Mattthei — Sat, 16 Nov 2024 01:34:02 GMT

Hi,

I have a datatabel and script which is pretty straight forward:

Hierarchy(Material,HeadMaterial,MaterialName) Load Material, HeadMaterial, MaterialName from Table1;

From this I created an hierarchy, no problem. But the challange here:

In every nod, the nod itself contains more nodes and the node is found in the Parent field, with no connection to the "original" parent. So this is the hierarchy I get (Notice material 3 is found both as node and as parent)

HeadMaterial	Submat 1	Submat 2	Submat 3	Submat 4
1	2	3	4
3	5	6	7	9
7	10	15

This is what I need, you see that HeadMaterial 3 an is found under HeadMaterial 1 but lacks the submaterials included. Same for material 7 but under material 3 instead. Note that material 3 and 7 can have diffrent parents with no restriction to how many.

HeadMaterial	Submat 1	Submat 2	Submat 3	Submat 4	Submat 5	Submat 6	Submat 7
1	2	3	4
			5	6	7	9
						10	15

Any suggestions on how the create an single hieracy including ALL submaterials?

Thanks in advance!

Re: Hierarchy where node is parent

AbhijitBansode — Mon, 31 Aug 2020 13:51:40 GMT

I Understand you have table with Adjacent nodes. Please check if HierarchyBelongsTo can help.

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/HierarchyBelongsTo.htm

However if still facing issue, post sample data in the thread.

Qlikgards,

topic Hierarchy where node is parent in App Development

Hierarchy where node is parent

Re: Hierarchy where node is parent