Discussion Board for collaboration on QlikView Scripting.
Im trying build a dimension from a table which has a parent child relationship.
The tables includes the following parent child:
Trust Cost Pools
Patient based income
Radiology OP Income
So the results returned should be:
How can i build this into my script?
Go to Solution.
I have published a document on that topic:
There are many docs on Hierarchical topic. You will find sth useful, I am sure.
Have a nice reading
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.
I have now managed to do this. This is a great document which is very clear.
Thank you very much for this.
The SQL should be very similar to the XLS one.
Use attached QVW for reference to better understand hierarchical function. ..
Sorry there is no attachment.