topic Re: Display Only Parent Attributes in Hierarchical Dimension in App Development

Display Only Parent Attributes in Hierarchical Dimension

Anonymous — Sat, 06 Feb 2016 15:38:28 GMT

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

Re: Display Only Parent Attributes in Hierarchical Dimension

swuehl — Sat, 06 Feb 2016 17:07:01 GMT

Maybe like this?

Re: Display Only Parent Attributes in Hierarchical Dimension

Anonymous — Sat, 06 Feb 2016 18:56:37 GMT

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?

Re: Display Only Parent Attributes in Hierarchical Dimension

swuehl — Sat, 06 Feb 2016 23:42:19 GMT

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.

Re: Display Only Parent Attributes in Hierarchical Dimension

Anonymous — Sun, 07 Feb 2016 01:16:50 GMT

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