Buenos Noches,
Como hacer esta requeta en Qlikview porfavor:
select a.attribut_champ
from table1 a,
table2 b,
table3 c
where b.person_id = a.person_id
AND NOT EXISTS (SELECT 1
FROM table2 d
WHERE b.person_id = d.person_id
AND d.start_date > b.start_date)
AND NOT EXISTS (SELECT 1
FROM table1 d
WHERE a.person_id = d.person_id
AND d.start_date > a.start_date)
and c.agent_id = b.person_id
and c.header_id = pn_header_d
