Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

Is this a join of some sort?

I have this SQL which I'm trying to replicate in Qlikview. How do I do outer joins in qlikview

select *

from gl_je_headers gjh,

gl_je_lines gjl,

ap_invoices_all aia,

po_vendors pv,

ap_invoice_distributions_all aida

where gjh.je_header_id = gjl.je_header_id

and aida.invoice_id(+) = gjl.reference_2  -- (how do I do this and the next two lines?)

and aida.distribution_line_number(+) = gjl.reference_3

and aida.invoice_id = aia.invoice_id(+)

and gjh.je_source = 'Payables'

regards

Mina

0 Replies