Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Parent Child Dimension

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

6 Replies
Not applicable

Re: Parent Child Dimension

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

Re: Parent Child Dimension

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

Re: Parent Child Dimension

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

Re: Parent Child Dimension

Excellent

The SQL should be very similar to the XLS one.

Fabrice

brijesh1991
Valued Contributor

Re: Parent Child Dimension

Hey,

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

Regards,

Brijesh

Not applicable

Re: Parent Child Dimension

Hi

Sorry there is no attachment.

Community Browser