topic Re: Finding other children in QlikView

Finding other children

Thu, 05 Dec 2013 09:53:18 GMT

Hi,

I have a list of names for parents and their kids. Every kid has one family and one family can have several kids. What I want to do know is to find one child's siblings by selecting that kid. For example: the Smith family have four kids, Aiden, Daniel, Matthew, and Elijah. Now if I select Aiden, I would like the table to show me the entire family, that is the names of all his siblings. I have attached a file, please have a look!

Cheers,

Re: Finding other children

Thu, 05 Dec 2013 10:03:48 GMT

Hi Nils

here is one possible solution

best regards

Chris

Re: Finding other children

sujeetsingh — Thu, 05 Dec 2013 10:23:58 GMT

Chris

Can you please explain the qualify and unqualify function ??

Re: Finding other children

Thu, 05 Dec 2013 10:26:53 GMT

this works perfectly! thank you!

would you mind however explaining a bit what you have done here ?

Re: Finding other children

Thu, 05 Dec 2013 10:39:39 GMT

QUALIFY * will prefix the field names by the name of the table

let's say

T1:

Load A, B, C....from ....

will give T1.A, T1.B, T1.C

this is an automatic alias

unqualify field name will revoke Qualify for indicated fileds or * (all)

best regards

chris

Re: Finding other children

Thu, 05 Dec 2013 10:41:03 GMT

tnx. how does the binary function enter in to this? and where do you actually load the data? i would have expected a FROM statement somewhere ....

Re: Finding other children

Thu, 05 Dec 2013 10:47:22 GMT

Nils

binary loads your qvw because I hadn't the xls file.

I added a second table link to your original thru Parent (actually don't do this but load a specific key in both tables like Parent as %P and unqualify %P)

So both tables are the same of deliver a 1 to n relation

best regards

chris

Re: Finding other children

Thu, 05 Dec 2013 10:51:00 GMT

ok, so if i understand you correctly i can achieve the same thing by doing something like:

Main:

LOAD Parent,

Child,

ChildFullname,

Month

FROM

(biff, embedded labels, table is Sheet1$);

T2:

LOAD Parent,

Child as T2.child,

FROM

(biff, embedded labels, table is Sheet1$);

Re: Finding other children

Thu, 05 Dec 2013 13:45:57 GMT

Yes exactly

but my advice is you duplicate PArent field as %P because it is not recommanded to use key in graphs

best regards

Chris