5 Replies Latest reply: May 28, 2015 9:33 AM by Ramon Covarrubias RSS

    Hierarchical in qlikview

    hana alsaleh

       

       

      how to bring Hierarchical from SAP to Qlikview not as flat table

      I have table ‘PA0001‘ filed ‘ORGEH’ to Map with table ‘HRP1001’ filed ‘SOBID’

        • Re: Hierarchical in qlikview
          Robert Mika

          Could you provide more details/data?

            • Re: Hierarchical in qlikview
              hana alsaleh

              how to achieve Organizational Hierarchy to find the employee count. There is a table HRP1001 which has the parent & child information. A child itself can be also a parent.

              Parent filed 'HRP1001.OBJID '

              chiled Filed 'HRP1001.SOBID '

              mapping with PA0001.ORGAH

              I want to count in all the level from Top to button

            • Re: Hierarchical in qlikview
              Nandha Kumar

              ya Robert said pls send the details of your questions? This is not clear.

                • Re: Hierarchical in qlikview
                  hana alsaleh

                  how to achieve Organizational Hierarchy to find the employee count. There is a table HRP1001 which has the parent & child information. A child itself can be also a parent.

                  Parent filed 'HRP1001.OBJID '

                  chiled Filed 'HRP1001.SOBID '

                  mapping with PA0001.ORGAH

                  I want to count in all the level from Top to button

                    • Re: Hierarchical in qlikview
                      Ramon Covarrubias

                      have you tried with Hierarchy function?

                       

                       

                      Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement | selectstatement)

                      where

                      NodeID is the name of the field that contains the node id. This field must exist in the input table.

                      ParentID is the name of the field that contains the node id of the parent node. This field must exist in the input table.

                      NodeName is the name of the field that contains the name of the node. This field must exist in the input table.

                      ParentName is a string used to name the new ParentName field. If omitted, this field will not be created.

                      PathSource is the name of the field that contains the name of the node used to build the node path. Optional parameter. If omitted, NodeName will be used.

                      PathName is a string used to name the new Path field, which contains the path from the root to the node. Optional parameter. If omitted, this field will not be created.

                      PathDelimiter is a string used as delimiter in the new Path field. Optional parameter. If omitted, ‘/’ will be used.

                      Depth is a string used to name the new Depth field, which contains the depth of the node in the hierarchy. Optional parameter. If omitted, this field will not be created.

                      Example:

                      Hierarchy(NodeID, ParentID, NodeName) LOAD

                      NodeID,

                      ParentID,

                      NodeName,

                      Attribute

                      FROM data.xls (biff, embedded labels, table is [Sheet1$];