2 Replies Latest reply: Dec 20, 2012 6:05 AM by Vishwaranjan Kumar RSS

    joining two tables

      Hi,

       

      I am new to qlikview, I am trying to join two tables, for the both tables customer number is the common field.

       

       

      First I am trying to get a Filter like this Category--> Credit In Process

                                                                                Credit Received

                                                                                Rounded

       

      Next I would like to create a pivot table in the dim as Category, Invoice Number with a expression of Count of Invoices.

       

       

      The First table has the following fields like

       

      Customer Number, Invoice Number, Shipdate, Delivery date, Import No, Freight, Tax, Vat, Extra_Changes, Amount

       

      In my Next table it has Customer Number, Credit Note Number, Credit Amount, etc..

       

      In the script it looks like this.

       

      Test:

       

      Load

      Customer Number,

      Invoice Number,

      Shipdate,

      Delivery date,

      If(Import No=0,'Rounded') as 'Rounded,

      Freight,

      Tax,

      Vat,

      Extra_Changes,

      Amount,

      If (Amount <0,'Credit In Process') as Credit In Process


       

      From Invoice.qvd(QVD).

       

      Test1:

       

      Load

       

      Customer Number,

      Credit Note Number,

      If(Credit Amount <0, 'Credit Received' as 'Credit Received'

      ..

       

      From Credit.qvd(QVD)