topic Complex self linkage issue in QlikView

Complex self linkage issue

Tue, 22 Oct 2013 14:34:20 GMT

Hello,

Every task has taskID, and may have taskRunID. Now all the taskRunID references to other task's taskID. so for example,

index, taskID, taskRunID, otherAttributes

1, 6f45, 0000, otherAttributes

2, 3gh5, 6f45, otherAttributes

3, 6xfg, 6f45, otherAttributes

4, eegh, 6hyu, otherAttributes

now what I want to do in pivot table is

MAIN TASK	SUB TASK
6f45	3gh5
	6xfg
6hyu	eegh
.....	.....

... and so forth and I have no idea how to even begin.

Thank you for your time and consideration.

Re: Complex self linkage issue

marcus_malinow — Tue, 22 Oct 2013 14:46:25 GMT

Hi,

this is one of those issues that I run in to from time to time, and it seems I need to relearn how to solve the problem each time.

It looks like you have an 'adjacent nodes' table - you may wish to use the Hierarchy keyword to expand this in to an expanded nodes table. Here is a document showing some (very) basics. I'd suggest referring to the reference manual for more detail.

http://community.qlik.com/servlet/JiveServlet/download/119319-14986/QV%20Hierarchy.docx

Marcus