topic Re: How to Create a Hierarchy in QlikView

How to Create a Hierarchy

Tue, 22 Dec 2015 22:12:23 GMT

How do you create a collapsible hierarchy? I need a tree view that is similar to this which will be imported from Excel.

1.0 - Top Level 1

1.1

1.1.1

1.1.2

1.2

2.0 - Top Level 2

3.0 - Top Level 3

3.1

3.1.1

4.0 - Top Level 4

Top levels only would have a description attached to the number. All of this is available in and Excel sheet where one column is the requirement number and the second field is the description. Short descriptions are present for top levels.

For Example

Req # Description

1.0 Top Level 1

1.1 Requirement 1...............

1.1.1 Requirement 1...............

1.1.2 Requirement 1...............

2.0 Top Level 2

Re: How to Create a Hierarchy

MarcoWedel — Wed, 23 Dec 2015 00:28:04 GMT

Hi,

maybe one solution could be:

table1:
Hierarchy(ReqID,ParentReqID,[Req #],,ReqPathSource,'ReqPath')
LOAD Text([Req #]) as [Req #],
    Text([Req #]) as ReqID,
    Text(Left([Req #],Index([Req #],'.',-1)-1)&If(SubStringCount([Req #],'.')=1,'.0')) as ParentReqID,
    Text(If([Req #] like '*.0', [Req #]&' - '&Description, [Req #])) as ReqPathSource,
    Description
Inline [
    Req #, Description
    1.0, Top Level 1
    1.1, Requirement 1...............
    1.1.1, Requirement 1...............
    1.1.1.1, Requirement 1...............
    1.1.2, Requirement 1...............
    1.2, Requirement 1...............
    2.0, Top Level 2
    3.0, Top Level 3
    3.1, Requirement 1...............
    3.1.1, Requirement 1...............
    4.0, Top Level 4
    4.1, Requirement 1...............
    4.1.1, Requirement 1...............
    4.1.2, Requirement 1...............
    4.1.2.1, Requirement 1...............
    4.1.2.2, Requirement 1...............
    4.2, Requirement 1...............
    4.2.1, Requirement 1...............
    4.2.2, Requirement 1...............
    4.2.3, Requirement 1...............
];

hope this helps

regards

Marco

Re: How to Create a Hierarchy

Wed, 23 Dec 2015 12:58:51 GMT

This works perfect but is there also a way to keep track of the highest parent id and description. Even if we are three levels down.

For example i need a variable with data that tells me that requirement 4.2.1 is under the category 4.0 - Top Level 4.

Thanks,