Linking table

zagzebski — Wed, 02 Oct 2013 13:57:52 GMT

This is an abbreviated view of my linker table with two tables that join to it.

LINKER TABLE
SALES\|KEY	DEPARTMENT\|KEY	CUSTOMER\|KEY	PRODUCER\|KEY
SALES1	SALES	ABC Corp.	(null)
(null)	SALES	ABC Corp.	PROD1

PRODUCER TABLE
PRODUCER\|KEY	Percentage
PROD1	0.9

SALES TABLE
SALES\|KEY	Commission
SALES1	10000

With the structure above is it possible to write an expression that takes the "Percentage" multiplied by the "Commission" based on the Department|Key and the Custiomer|Key being the same....even though there are nulls in the Producer|Key and Sales|Key? Or is it impossible to correlate the values because there is no true relationship between the Producer table and the Sales table?

Re: Linking table

srchilukoori — Sat, 05 Oct 2013 16:18:11 GMT

The expression "Percentage*Commission" would work. However, from the data in the above link table, there are nulls in the records for SALES|KEY and PRODUCER|KEY, so it will return nulls.

topic Re: Linking table in QlikView

Linking table

Re: Linking table