7 Replies Latest reply: May 12, 2011 2:17 PM by bharadwaj pavuluri RSS

    Regarding tree view

      Hello everyone ,

       

      I need some information regarding tree views

       

      I got a hierarchal data of large volume and I want to display it in a tree view using a pivot table ,

      I can't go for a tree view in a list box because I want some brief like a  summary also Is that possible ???

       

      If it's not possible can u suggest me by using which chart/box I can display the data in a tree view

       

      Thankyou all in advance

       

       

      Thanks ,

      Bradd

        • Regarding tree view
          Stephen Redmond

          Hi Bradd,

           

          Are you v10?  If so, you can add an expression to a list box - even a hierarchical one.

           

          You can also use the Hierarchy function in QlikView to split data that is hierarchical into multiple fields that can be used in a pivot.  Check out the help file.

           

          Regards,

           

           

          Stephen

            • Regarding tree view

              Thanks Stephen ,

               

              But I want to display multiple columns and I want to display partial sum for some branches/parent nodes in hierarchy

              So can I do that in a pivot ???

              And regarding the hierarchy function can u tell me a little bit in brief ...

               

              Thanks,

              Bradd

                • Regarding tree view
                  Toni Kautto

                  That should be no problem to project in a pivot table. Please attach a sample QVW where you have loaded a portion of your data, to make evaluating your situation a bit easier.

                    • Regarding tree view

                      Thanks for your reply Toni ,

                       

                      But actually I have a requirement for this which is still in process and I'm asking this because if it can work in pivot then I'll go for it or else I have to seek for a alternative . Like tree view in a list box and the remaining separately in another box/table & On what type of data it is gonna works ( I mean recursive or flattened data )

                       

                      So if you don't mind can u share ur idea in what case that the tree view in pivot is gonna work.

                       

                       

                       

                      Thanks,

                      Bradd

                    • Regarding tree view
                      Stephen Redmond

                      Hi,

                       

                      You may need to go down the Hierarchy route.

                       

                      Not much point in me telling you more about it here as it is already so well described in both the help file and the reference manual.

                       

                       

                      Regards,

                       

                       

                      Stephen