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

    Column Row relation in QV

    Moreed Murrar Oct 13, 2011 5:43 AM

      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
          Dennis Hoogenboom Oct 13, 2011 6:12 AM (in response to Moreed Murrar )

          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
              Moreed Murrar Oct 13, 2011 8:58 AM (in response to Dennis Hoogenboom )

              Dear Dennis,

              unfortunatly this didnt help!

               

              regards,

              Moreed

                • Re: Column Row relation in QV
                  Dennis Hoogenboom
                  Dennis Hoogenboom Oct 14, 2011 6:11 AM (in response to Moreed Murrar )

                  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.