Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Linking table

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

LINKER TABLE
SALES|KEYDEPARTMENT|KEYCUSTOMER|KEYPRODUCER|KEY
SALES1SALESABC Corp.(null)
(null)SALESABC Corp.PROD1
PRODUCER TABLE
PRODUCER|KEYPercentage
PROD10.9
SALES TABLE
SALES|KEYCommission
SALES110000

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?

1 Reply
srchilukoori
Valued Contributor

Re: Linking table

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.

Community Browser