Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Left Joins - reference from table I am joining to

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

2 Replies
MVP & Luminary
MVP & Luminary

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

Specialist II
Specialist II

Hi

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;