Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to do multiple joins in qlikview

select dj.id, dj.OpDate,dj.idPhysicalPerson, dr.idGoods,g.Name,dr.Amount
from DocJournal as dj
join drSales as dr on dr.idDoc = dj.id
join refPhysicalPersons as pp on pp.id = dj.idPhysicalPerson
join refGoods as g on g.id = dr.idGoods
where dj.idPhysicalPerson in (123124,123125,123126)
and dj.deleted= 0