Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have been trying to show only "Status" of parent tasks in a hiearchical dimension (similar to Microsoft Project) where you can drill down, see only sub-tasks of selected parent tasks, and show status for each of the displayed tasks, but having difficulties.
Attached is a sample data.
When there is no selection, I would like to see
Task 1 Status
Plan On Schedule
Execute Future
Instead, I am getting
Task 1 Status
Plan Complete
Plan Late
Plan On Schedule
Execute Future
Regards,
Muliady
Ok.
I've just loaded the excel file without any transformation:
LOAD TaskID,
[Outline Level],
[Task Name],
[Task 1],
[Task 2],
[Task 3],
Status,
[Status ID]
FROM
[Tasks Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);
Then I've created a drill down dimension group GRP in the frontend, with fields [Task 1], [Task 2], [Task 3].
I've created a straight table chart with dimension GRP and enabled option 'Supress when Values is NULL' on dimension tab.
One expression:
=FirstSortedValue(Status, TaskID)
That's it. It's relying on TaskID for parents being smaller than TaskID for children, if this is not the case, you would need to find something else to sort your status by.
Maybe like this?
Hi Swuehl, thank you for the response, but I cannot open it because I do not have qlikview license. Is it possible to put your response in Qlik Sense qvf, or share the script / formula?
Ok.
I've just loaded the excel file without any transformation:
LOAD TaskID,
[Outline Level],
[Task Name],
[Task 1],
[Task 2],
[Task 3],
Status,
[Status ID]
FROM
[Tasks Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);
Then I've created a drill down dimension group GRP in the frontend, with fields [Task 1], [Task 2], [Task 3].
I've created a straight table chart with dimension GRP and enabled option 'Supress when Values is NULL' on dimension tab.
One expression:
=FirstSortedValue(Status, TaskID)
That's it. It's relying on TaskID for parents being smaller than TaskID for children, if this is not the case, you would need to find something else to sort your status by.
Swuehl, that works great!! Thank you so much!