Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi
I have now managed to do this. This is a great document which is very clear.
Thank you very much for this.
Excellent
The SQL should be very similar to the XLS one.
Fabrice
Hey,
Use attached QVW for reference to better understand hierarchical function. ..
Regards,
Brijesh
Hi
Sorry there is no attachment.