Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mhartono
Contributor

Display Only Parent Attributes in Hierarchical Dimension

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Display Only Parent Attributes in Hierarchical Dimension

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.

4 Replies
MVP
MVP

Re: Display Only Parent Attributes in Hierarchical Dimension

Maybe like this?

mhartono
Contributor

Re: Display Only Parent Attributes in Hierarchical Dimension

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?

MVP
MVP

Re: Display Only Parent Attributes in Hierarchical Dimension

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.

mhartono
Contributor

Re: Display Only Parent Attributes in Hierarchical Dimension

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