12 Replies Latest reply: Feb 12, 2014 3:54 AM by Henric Cronström RSS

    Hierarchy tree

      Hi,

       

      I'd like to make a hierarchy tree out of my database.

      Here is an example of my data:

       

      Level    GroupID       GroupName       IdGroupparent

       

      0            22550        Test1                

      1            22551        Test2                  22550

      1            22552        Test3                  22550

      1            22553        Test4                  22550

      2            22554        Test5                  22551

      2            22555        Test6                  22551

      3            22556        Test7                  22554

      4            22557        Test8                  22556

       

      Basically I'd like to build a view like the following suggested in this post: Hierarchy List

       

      However they're using the 'Path' to build the table below. I'd like to automatically be able to organize my Groups from top to bottom.

      I've got a maximum of 6 levels.

      Result would look like this:

       

      Test1

               Test2

                         Test5

                                 Test7

                                         Test8

                         Test6

               Test3

               Test4

       

      Sorry I'm a bit new to Qlikview, if you can provide me some help that would be great.

       

       

      Thanking you in advance,

      Cédric