topic Re: Hierarchy in QlikView

Hierarchy

Anonymous — Wed, 10 Jul 2013 07:41:42 GMT

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

Re: Hierarchy

kaushiknsolanki — Wed, 10 Jul 2013 07:46:50 GMT

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

Re: Hierarchy

Wed, 10 Jul 2013 07:48:57 GMT

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

Re: Hierarchy

kaushiknsolanki — Wed, 10 Jul 2013 07:53:57 GMT

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

Re: Hierarchy

Wed, 10 Jul 2013 08:18:45 GMT

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

Re: Hierarchy

Anonymous — Wed, 10 Jul 2013 08:30:18 GMT

Thanks Kaushik!

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

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

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