topic Re: Creating a self join Hierarchy in QlikView

Creating a self join Hierarchy

Mon, 10 Jun 2013 14:28:51 GMT

Im trying to create a hiererachy on a table using the self join between the LocalServiceLineParent and LocalServiceLine.:

SELECT .LocalServiceLine, .LocalServiceLineDescription,

.LocalServiceLine + ' : ' + .LocalServiceLineDescription AS LocalServiceLineDescriptionWithCode,

LocalServiceLineParent

FROM LocalServiceLines

I have tried this in SQL but unfortunatley the results are not returining as expected.

Thanks

Mon, 10 Jun 2013 15:20:03 GMT

what do you expect? and what you get? and where is self join?

Mon, 10 Jun 2013 15:22:07 GMT

The parent is LocalServiceLineParent and the child is LocalServiceLine. I need these two join to create a hierarchy.