2 Replies Latest reply: Oct 12, 2011 9:56 AM by cloverbz RSS

    Joining tables

      I am new to QlikView and now facing problems to perform margin analysis due to failure to join tables.

      I have 4 tables:

       

      SalesHeaderSalesDetailsOrderHeaderOrderDetails
      F1FANRF2FANR as F1FANRKEORNR as OrderNumberKAORNR as OrderNumber
      F1FADT as DateF2FADTKELIJN as OrderLineNumberKAFACN
      F1MUNTF2ORNR as OrderNumberKECODEKAKNUM
      F1KNUMF2LIJN as OrderLineNumberKEAANTKACRED as Date
      F1FACNF2CODEKEPRIXKAMUNT
      F1VERTF2TFAKKEFIFOKAMULT
      F2BOEKKEFISC
      F2PRIXKEKOMS
      KEKITR

       

      To calculate the margin, I need F2TFAK*F2PRIX - F2TFAK*KEFIFO

      I do not succeed in joining the tabels correctly. 

      When I look at the table viewer, I get values for the fields of the tables 'SalesHeader' and 'SalesDetails', but not for the 'OrderHeader' and 'OrderDetails' tables (I joined the tables using 'left join').

      Any suggestions to resolve my problem ?

      Many thanks !

       

      Davy

        • Joining tables
          SalesHeaderSalesDetailsOrderHeaderOrderDetails
          F1FANRF2FANR as F1FANR

          KEORNR as OrderNumber1

          KEORNR as OrderNumber2

          KAORNR as OrderNumber1
          F1FADT as DateF2FADTKELIJN as OrderLineNumberKAFACN
          F1MUNTF2ORNR as OrderNumber2KECODEKAKNUM
          F1KNUMF2LIJN as OrderLineNumberKEAANTKACRED as Date
          F1FACNF2CODEKEPRIXKAMUNT
          F1VERTF2TFAKKEFIFOKAMULT

          F2BOEKKEFISC

          F2PRIXKEKOMS


          KEKITR




            Try this?

           

          Can you share a image of how the table joins look?

          • Joining tables

            Name AS,(Rename fields) then use them to link,Comment out and copy for backup in case something happens,

            If u can mess with the source of this sheet...(If excel)then add something with the same name in each table as in:

             

             

            FRONT then next table would be FRONT-2 etc....

            U can use that to see how u will structure ur joins,its a lot simpler but different things work for different people,goodluck mate