How can I rewrite this in QlikView

[neerajthakur]

LEFT OUTER JOIN VisualInspection VI ON VI.ConsigmentID = INSP.ConsigmentID AND CASE WHEN VI.ItemCode IS NOT NULL THEN VI.ItemCode ELSE 1 END = CASE WHEN VI.ItemCode IS NOT NULL THEN INSP.ItemCode ELSE 1 END

How can  I achieve this in QlikView? I can't find any examples for joining like this in Qlik

[stevejoyce]

VI:

VI.ConsignmentID as ConsignmentID,

if(not isnull(VI.ItemCode), VI.ItemCode, 1) as ItemCode

from VisualInspection

;

left join (VI)

INSP.ConsignmentID as ConsignmentID,

if(not isnull(INSP.ItemCode), INSP.ItemCode, 1) as ItemCode

from INSP

;