topic Re: Left Joins - reference from table I am joining to in QlikView

Left Joins - reference from table I am joining to

Anonymous — Tue, 10 Sep 2013 13:36:26 GMT

Hi - is it possible to reference from the table I am joining to when using a left join

In the example, UNIQUE_MPAN_PER_ICE is a field within TABLE1

LEFT JOIN (TABLE1)
LOAD TEAMS,
VALUE_PER_CUSTOMER/UNIQUE_MPAN_PER_ICE
RESIDENT VPC;

DROP TABLE VPC;

Thanks

Nandy

Re: Left Joins - reference from table I am joining to

marcus_sommer — Tue, 10 Sep 2013 13:56:05 GMT

This won't work directly within join - after joining you could it calculate. Perhaps it is better for this to use a mapping with applymap() - for examples and explanations see the manual.

- Marcus

Re: Left Joins - reference from table I am joining to

gandalfgray — Tue, 10 Sep 2013 14:11:06 GMT

To do calculations on a table do a RIGHT JOIN on itself.

If I alter your example a bit it will be like this:

LEFT JOIN (TABLE1)
LOAD TEAMS,
VALUE_PER_CUSTOMER
RESIDENT VPC;

DROP TABLE VPC;

RIGHT JOIN (TABLE1)
LOAD *,
VALUE_PER_CUSTOMER/UNIQUE_MPAN_PER_ICE As CalculatedField
RESIDENT TABLE1;