issue with hierarchy

[beck_bakytbek]

Hi Folks,

i got a Problem, my table has 4 Fields as Node1, Node32, Node3 and Node4, i tried to build the hierarchy but i didn,t achieve any expected results (Hierarchy).

my expected Output is:

Node1 consist of Node2, and Node2 consists of Node3, and Node3  consists of / or refers to Node4.

I attached the example-file, does anybody have any idea how to solve this issue?

Thanks a lot

Beck

[Edvin]

How about creating a new drill-down dimension with all of those 4 fields?

[beck_bakytbek]

Hi Edvin,

i know that i can use this Option, but i want to know, how to solve with the help of function: Hierachy

[Lucke_Hallbergson]

Hi,

You might want to read the following 2 blog posts by HIC;

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

https://community.qlik.com/t5/QlikView-Documents/Hierarchies/ta-p/1487801

Best Regards
Lucke

[lironbaram]

hi 

have a look at the attach example 

although i must say , you have the data in hierarchy already

 so it's doesn't make a lot of sense using the hierarchy function 

[beck_bakytbek · Accepted solution]

Hi Aqu,

thanks a lot for time and help

[beck_bakytbek]

Hi Lironbaram, thanks a lot for your help and time