topic Re: Load Hierarchy on each level as level 1 in QlikView

Load Hierarchy on each level as level 1

amien — Mon, 03 Oct 2016 21:11:52 GMT

I use the Hierarchy functie to create a table like this:

Name1, Name2, Name3, Name4, Name5 etc..

This all works.

How i want each part of the hierarchy also to be available in Name1.

What i could do something like this:

t2:

LOAD Name1, Name2, Name3, Name4, Name5 RESIDENT t1

Concatenate (t2)

Name2 As Name1, Name3 As Name2, .... RESIDENT t1;

Concatenate (t2)

Name3 As Name1, Name4 As Name2, .... RESIDENT t1;

Anyone has a better way to do this?

I need this table as a staging table for a PL

Thanks in advanced

Re: Load Hierarchy on each level as level 1

el_aprendiz111 — Mon, 03 Oct 2016 21:15:31 GMT

Hi,

1 Example

Re: Load Hierarchy on each level as level 1

amien — Mon, 03 Oct 2016 22:35:36 GMT

@fer fer

i dont quite get it.

my original source has 2 fields NodeID and ParentID (+naming)

Then i do a HIERARCHY load. and it will give me the needed hierarchy with Name1,Name2 etc.. (quite a few levels).

But not all levels have the same depth. Some are 4 deep, others like 7 for example.

Then i need to concatenate Name2 until the end to Name1. So all levels need to shift 1 level up.

I dont see how this fits in your "-SEM" etc solution. can you example how i should transform this above explanation into your example?

Re: Load Hierarchy on each level as level 1

el_aprendiz111 — Mon, 03 Oct 2016 22:41:12 GMT

Hi,

send me a sample data.

Re: Load Hierarchy on each level as level 1

MarcoWedel — Mon, 03 Oct 2016 22:52:24 GMT

can you elaborate on what you are trying to do with the resulting table?

Did you take a look at the HierarchyBelongsTo prefix as well?

regards

Marco

Re: Load Hierarchy on each level as level 1

amien — Mon, 03 Oct 2016 22:56:01 GMT

I'm trying the get the PL in the proper order. Level 2 needs to show up as Level 1 to. And some Level 3 needs to be shown on level 1 also (with the lower levels aswell).

Yes, i have the HierarchyBelongsTo functions working, but i'm not sure how to get the needed results from that. Because this functions will give me all the possible combination for each level. But then what?

Re: Load Hierarchy on each level as level 1

amien — Mon, 03 Oct 2016 23:16:57 GMT

i added an example in the first post

Re: Load Hierarchy on each level as level 1

el_aprendiz111 — Tue, 04 Oct 2016 01:18:39 GMT

Hi,