Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Complex self linkage issue

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 TASKSUB TASK
6f453gh5
6xfg
6hyu eegh
..........

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

Thank you for your time and consideration.

1 Reply
marcus_malinow
Partner - Specialist III
Partner - Specialist III

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