Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Parent Child Dimension

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

           10

      Income

           CT_OPI


How can i build this into my script?


Many Thanks


1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

6 Replies
Not applicable
Author

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

Not applicable
Author

Hi

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

Not applicable
Author

Hi

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

Thank you very much for this.

Not applicable
Author

Excellent

The SQL should be very similar to the XLS one.

Fabrice

brijesh1991
Partner - Specialist
Partner - Specialist

Hey,

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

Regards,

Brijesh

Not applicable
Author

Hi

Sorry there is no attachment.