Hello Everyone,
I have the below table (project_task) for the tasks and subtasks.
The tree looks something like this (X,Y,Z,A,D are root nodes):
I have a table(task_tree_format) like this in database, which depicts the project tasks in depth format:
I want to place the name1, name2 and name 3 in pivot table so that it appears in hierarchical format(with expand and collapse buttons) in my Qlik Sense sheet.
My requirement is -
When task 'B' (NAME2 column) is selected in pivot table, it should perform the operation based on the same 'Task Name' in project_task table.
Eg.. If I select Task 'B' in pivot table, it should trigger the 'Task Name' B in project_task table.
In short, I want to associate NAME1, NAME2 and NAME3 columns with the 'Task Name' column in project_task.
I request your help on how to proceed with this in the load data editor.
Appreciate your help regarding this.
Thanks!
Sagnik