Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
Can you attach the sample file.
Regards,
Jagan.
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