Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Script comparacion de campos en tablas anidadas a partir de QVD

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

0 Replies