joining two tables

Thu, 20 Dec 2012 10:09:35 GMT

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)

Re: joining two tables

jagan — Thu, 20 Dec 2012 10:33:16 GMT

Hi,

Can you attach the sample file.

Regards,

Jagan.

Re: joining two tables

Thu, 20 Dec 2012 11:01:29 GMT

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

topic Re: joining two tables in QlikView

joining two tables

Re: joining two tables

Re: joining two tables