Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
neerajthakur
Creator III
Creator III

How can I rewrite this in QlikView

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

Thanks & Regards,
Please Accepts as Solution if it solves your query.
1 Reply
stevejoyce
Specialist II
Specialist II

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

;