Display Only Parent Attributes in Hierarchical Dimension

[Anonymous]

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

[swuehl]

Maybe like this?

[Anonymous]

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?

[swuehl · Accepted solution]

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.

[Anonymous]

Swuehl, that works great!! Thank you so much!