This content has been marked as final. Show 2 replies
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
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.
If(Import No=0,'Rounded') as 'Rounded,
If (Amount <0,'Credit In Process') as Credit In Process
Credit Note Number,
If(Credit Amount <0, 'Credit Received' as 'Credit Received'