joining two tables

[#1]

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)

[jagan]

Hi,

Can you attach the sample file.

Regards,

Jagan.

[#3]

use inner join function

Examples:

Table1
A	B
1	aa
2	cc
3	ee

Table2
A	C
1	xx
4	yy

QVTable:

select * from table1;

inner join select * from table2;

QVTable
A	B	C
1	aa	xx

you can use LOAD replacing select

hope this will help you