topic Re: Two fields in one table relate to another table in QlikView

Two fields in one table relate to another table

Fri, 22 Mar 2013 12:08:35 GMT

I have one table with two fields relating to the same table.

First table is called Invoice with the following colums:

InvoiceID
From_customer
To_Customer
Amount

Second is a customer table with the folowing colums:

CustomerID
Name

This is very simplified example but the issue is the same. From_Customer and To_Customer shoulde relate to the Customers table.

In my QVW i have a chart where i want to display Income and Cost, obviusly the Income amount and Cost Total shoulde be equal when all customers are selected.

When i select one or more customers i want to see if i have more income than cost.

I hope it makes more seen if you view the QVW i have provided as an Attachment.

Re: Two fields in one table relate to another table

Fri, 22 Mar 2013 12:20:47 GMT

Invoice:

InvoiceID,

From_customer,

To_Customer,

Amount

FROM Invoice;

customer :

LOAD

CustomerID AS From_customer,

CustomerID AS To_Customer,

Name

FROM customer;

Re: Two fields in one table relate to another table

Fri, 22 Mar 2013 13:33:55 GMT

This fixed the issue in regard to the two colums related to the same tabel, thanks. No i have to figure out out to count the Income vs Cost. Thanks for the help.