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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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