topic Re: Parent Child Dimension in QlikView

Parent Child Dimension

Tue, 10 Dec 2013 13:28:16 GMT

Hi all

Im trying build a dimension from a table which has a parent child relationship.

The tables includes the following parent child:

Parent	Child	Description
NULL	TRUST	Trust Cost Pools
	PBI	Patient based income
TRUST	Expense	Trust Expenditure
TRUST	Income	Trust Income
Expense	10	Ward Costs
Income	CT_OPI	Radiology OP Income

So the results returned should be:

TRUST

Expense

Income

CT_OPI

How can i build this into my script?

Many Thanks

Re: Parent Child Dimension

Tue, 10 Dec 2013 13:31:01 GMT

I have published a document on that topic:

http://community.qlik.com/docs/DOC-4823

There are many docs on Hierarchical topic. You will find sth useful, I am sure.

Have a nice reading

Fabrice

Re: Parent Child Dimension

Tue, 10 Dec 2013 14:54:29 GMT

Thanks for this.

I have done this but when I add the field to list box and the view the tree is displayed but without the text, just nodes.Can you please advise. My source data is a SQLtable.

Thanks

Re: Parent Child Dimension

Tue, 10 Dec 2013 15:11:56 GMT

I have now managed to do this. This is a great document which is very clear.

Thank you very much for this.

Re: Parent Child Dimension

Wed, 11 Dec 2013 07:59:22 GMT

Excellent

The SQL should be very similar to the XLS one.

Fabrice

Re: Parent Child Dimension

brijesh1991 — Wed, 11 Dec 2013 08:42:56 GMT

Hey,

Use attached QVW for reference to better understand hierarchical function. ..

Regards,

Brijesh

Re: Parent Child Dimension

Wed, 11 Dec 2013 09:16:31 GMT

Sorry there is no attachment.