Hierarchy

[Anonymous]

Hi all,

I have this:

Grandmother	Mother	Daughter
123	456	234
123	456	345
123	789	678
123	789	567

and I want this:

Grandmother	Mother	Daughter	Link field
123	456	234	234
123	456	345	345
123	789	678	678
123	789	567	567
123	456		456
123	789		789
123			123

The link field must consist of any number from all levels. When selecting the grandmother in Qlikview I want to see the figures of the mother and daughter but also the grandmother.

I hope you can help!

Best regards,

Arjan

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

     Load Distinct GrandMother,Mother,Daughter,Daughter as Link_Field from Table1;

     Concatenate

      Load Distinct GrandMother,Mother, Mother  as Link_Field from Table1;

     Concatenate

      Load Distinct GrandMother ,GrandMother as Link_Field from Table1;

Regards,

Kaushik Solanki

[#3]

Hi,

could you please help as I am not able to post new messages in qlikcommunity as it  is showing you need moderator permission to post

amelia

[kaushiknsolanki]

Dear Amelia,

     Due to the spam attack, every new message you post need to approve by moderator.

     There is nothing wrong in that, kindly wait for the approval and please stop posting the same thing in each and every post of others.

Regards,

Kaushik Solanki

[#5]

Ok Thanks.

Can you please help as I am getting below error please it's urgent..

I have a QVW file and when i tried to open month of June data it is getting Allocted Memory Exceeded in straight table and could anyone help in this why it's happening and there is 72GB RAM is allocated to server and 39GB RAM is free and 64 bit version

[Anonymous]

Thanks Kaushik!