4 Replies Latest reply: Dec 3, 2013 10:32 AM by Hans Müller RSS

    Listbox selection

    Hans Müller

      Hi,

      i have following table.

       

      Client Kennzahl1 Kennzahl2 Kennzahl3

      A 10 40 50

      B 25 35 45

      C 50 70 35

       

       

      Now, i want build two listboxes in qlikview. The first is selection on the field Client so this is easy but now i want to make a selection on Kennzahl1, Kennzahl2 and Kennzahl3. Is there any opportunity to make this row (Kennzahl1, Kennzahl2, Kennzahl3) available for selection in an list box.

       

      In QlikView there must be 2 listboxes like this:

       

      Client Kennzahlen

      A Kennzahl1

      B Kennzahl2

      C Kennzahl3

       

      I would be very happy if anyone knows something to build such selection.

       

      Thanks and regards,

      Thomas

        • Re: Listbox selection
          Tresesco B

          Use crosstable like:

           

          CrossTable (Kennzah, Amount, 1) Load *;

          Load * Inline [

          Client, Kennzahl1, Kennzahl2, Kennzahl3

          A, 10, 40, 50

          B, 25, 35, 45

          C, 50, 70, 35

          ]

           

          PFA

          • Re: Listbox selection
            Michele Barini

            Hi,

            maybe you can use the crosstable, so you have 2 dimension (Client, Kennzahl) and a measure (Data)

             

            Crosstable (Kennzahl, Data)

            LOAD * INLINE [

                Client, Kennzahl1, Kennzahl2, Kennzahl3   

                A, 10, 40, 50   

                B, 25, 35, 45   

                C, 50, 70, 35

            ];

            • Re: Listbox selection

              Thomas,

               

              Are kennZahlen dimension or measure ?

              If dimension, you should see crosstable keyword when loading your table

               

              You will get 2 dimensions: Client, KennZahlen

              and 1 measure that you will have to name.

               

              Fabrice

              • Re: Listbox selection
                Hans Müller

                Okay thank you. But now i have 3 excel sheets which have the same tables.

                 

                (Table Client A) (This table shows distances between A -> B,C)

                Client, Kennzahl1, Kennzahl2, Kennzahl3  

                    A, 0, 0, 0  

                    B, 25, 35, 45  

                    C, 50, 70, 35

                 

                (Table Client B) (This table shows distances between B -> A,C)

                Client, Kennzahl1, Kennzahl2, Kennzahl3  

                    A, 20, 30, 40  

                    B, 0, 0, 0  

                    C, 50, 70, 35

                 

                (Table Client C) (This table shows distances between C -> A,B)

                Client, Kennzahl1, Kennzahl2, Kennzahl3  

                    A, 40, 40, 40  

                    B, 10, 10, 40  

                    C, 0, 0, 0

                 

                Every month, there are new tablets created from a Java programm which will write the results into a excel csv sheet! This programm measures Distances between Clients and create for ever client one table.

                Now Qlik View should show the results in a digramm but with reference to the selection!

                 

                1.Listbox A, B, C (Clients)

                2.Listbox: A,B,C (Clients)

                3.Listbox: Kennzahl1, Kennzahl2, Kennzahl3

                 

                Example 1 :

                1.Listbox: Selection A

                2.Listbox: Selection B,C

                3.Listbox Selection Kennzahl1, Kennzahl2

                 

                Here i want to see how similar are B, C (2.Listbox) regarding to A (1.Listbox) with reference to Kennzahl1 and Kennzahl2 (3.Listbox)

                 

                Example 2 :

                1.Listbox:Selection B

                2.Listbox: Selection A,C

                3.Listbox: Selection Kennzahl1, Kennzahl2, Kennzahl3

                 

                I hope you understand what i mean and i hope that anyone got and idea how it could work. Maybe there is a solution which is completely different from my idea?

                 

                Thanks,

                Thomas