can i get this out of my hierarchy?

[amien]

i have created a hierarchy using qlikview's HIERARCHY functions. All works fine.

but now i want to create a pivot/table with two columns:

column 1: all first level material

column 2: all the materials, on the master material from column1, without any level lower. So this can be a level 3 material, but also a level 5 material.

example:

mat1 - mat2

mat1 - mat3 - mat4

mat1 - mat5

mat1 - mat6 - mat7

mat1 - mat8 - mat9 - mat10

my new list will be

mat1 - mat2

mat1 - mat4

mat1 - mat5

mat1 - mat7

mat1 - mat10

i tried it with subfield on the pathname .. but will all the material that are under mat1. including mat3 for example, which is nice, but not what i need

[swuehl · Accepted solution]

I think you can retrieve the information you need just by looking at the count of PartMat, an end of the hierarchy tree has a count of 1.

See attached.

[amien]

Sorry for my late reply, but i needed to find some time to test it on the production data.

Works very well swuehl .. Thank you very much!