3 Replies Latest reply: Oct 14, 2011 6:11 AM by Dennis Hoogenboom RSS

    Column Row relation in QV

      Dear All,

       

      We have 2 sheets "Input1" and "Input2" what is needed here is to create a dashboard that represents the "Output" Sheet.

       

      The "output" sheet is a combination of some values from "Input1" and "Input2" sheets.

       

      In the "Output" sheet - in the first row there are codes that represent codes in the "column Code" in "Input1" sheet.

       


      For example:

       

      Val4, Val5 and Val6 in "Output" sheet are connected with the codes in the "Input1" sheet that match with the same numbers in row 1 in "output" Sheet.

       

      Please note that the "output" sheet wont be loaded into QlikView!

       

       

      How can we connect the "input1" and "input2" sheets to create the "Output" sheet?

        • Re: Column Row relation in QV
          Dennis Hoogenboom

          Does this help:

           

           

          Input:
          LOAD 
             RecNo() as Key, 
                    Dim1, 
               Code, 
               Val1
          FROM
          Example1.xlsx
          (ooxml, embedded labels, table is Input1);
          
          
          Input2:
          Load 
                    RecNo() as Key, 
                    Dim2, 
               Val2
          FROM
          Example1.xlsx
          (ooxml, embedded labels, table is Input2);
          
          

          ?

           

           

          This way the information in the different sheets are connected based on the row number.

            • Column Row relation in QV

              Dear Dennis,

              unfortunatly this didnt help!

               

              regards,

              Moreed

                • Re: Column Row relation in QV
                  Dennis Hoogenboom

                  Hi Moreed,

                   

                  It doesn't make sence to me because the values (the calculations are different for the codes.

                   

                  But maybe you can start with this:

                   

                   

                  Input:
                  LOAD 
                            Dim1, 
                       Code, 
                       Val1
                  FROM
                  Example1.xlsx
                  (ooxml, embedded labels, table is Input1);
                  
                  //Input2:
                  Join (Input)
                  Load 
                            Dim2, 
                       Val2
                  FROM
                  Example1.xlsx
                  (ooxml, embedded labels, table is Input2);
                  
                  Input2:
                  Load * ,
                  ((Val1) * (Val2)) as Val4
                  Resident Input;
                  
                  Drop table Input;
                  
                  

                   

                  Like I said it doesn't make sence to me.

                  Maybe I can help you better is you can explain what it is you are trying to do. What your data is.