7 Replies Latest reply: Sep 12, 2013 2:53 PM by Michael Solomovich RSS

    How to make a list box of a table group

      Hi to you all!

       

      I'm new on this community/forum and relative new to Qlikview to.

      I've followed some courses and also an education of a few days learning to work with the design of Qlikview.

       

      When i'm making a pivot table with groups (ex. Agents, Country, Color, Customer)  in it, on the left side of this pivot table you see some sort of arrow where you can change your groups. Now here in our company soms people are complaining about that little arrow and would like to have for example a list box where the group name's (ex. Agents, Country, Color, Customer) are in and if you click that group name, the pivot table changes to that group like you change with that arrow.

       

      Could anyone tell me if this is possible? i've already tried to add a list box with a self made group but the list box just shows what is inside the group, in my example i would just like to see the group name in the list box.

       

      Thank you very much in advance!

       

      Kind regards

      Peter

        • Re: How to make a list box of a table group
          Nicole Smith

          I have attached an example of one way to do this.  I'll walk you through it a bit on this post.

           

          1.  I added some inline script to make your "group" that we will use in the list box.  We don't actually create a group in QlikView, it is just a field that contains the options that you want the user to have in the "group":

           

          Group:

          LOAD * INLINE [

          Group

          Agents

          Country

          Color

          Customer

          ];

           

          2.  This field is then just added to the list box (make sure to select one, then go back into properties and select always one selected value):

           

          3.  Then create a dimension on the chart that will determine what field to use depending on what is selected in group.

          • Re: How to make a list box of a table group

            Yes! that did it! thank you very much for the help with that!

            It's definitely something i have to and will remember

            • Re: How to make a list box of a table group

              To go a little deeper on this subject i have a question about renaming the items that are in that group.

               

              For now i have made a group like that:

               

              Group:

              LOAD * INLINE [

                  Group

                  Klanten.naam

                %key_KlantCode

                Artikel.Naam

                Artikel.Code

                Artikel.kleur

                Artikel.Geur

                Artikel.Units per pak

                Artikel.Merk

                Artikel.hoofd

                Artikel.Soort

                Artikel.Kleurmethode

                Artikel.Manier

                Vertegenwoordiger.Vertegenwoordiger naam

                Agent.Agentnaam

                Land.Continent

                Klanten.Land

                %key_Provincie

                Klanten.Markt segment

                Artikel.Diameter

                Artikel.Hoogte

                Artikel.gewicht

                Artikel.Kleur Pot/Glas/Schaal

              ];

               

              How can i change these names so that

               

              "Artikel.Naam" = "Naam"

              "Artikel.Code" = "Code" ?

               

              Also after changing these names do i have to use these names/labels into the script of the dimensions to? (I use the long version).

               

              Thanks for the help!