Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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)

2 Replies
MVP & Luminary
MVP & Luminary

Re: joining two tables

Hi,

Can you attach the sample file.

Regards,

Jagan.

Not applicable

Re: joining two tables

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