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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

How can I model the following bottom table in script

Hi Guys,

 

How can I get the bottom table from the top resident table?

Thanks

 

Top table Resident

NameDate 1order dateIdBefore_or_ after
John01/01/201001/01/20101Before
John01/01/201001/01/20101Before
John01/01/201001/01/20101Before
John01/01/201005/01/20102After
John01/01/201005/01/20102After
John01/01/201005/01/20102After
Paul01/01/201001/01/20103Before
Paul01/01/201001/01/20103Before
Paul01/01/201001/01/20103Before
Paul01/01/201005/01/20104After
Paul01/01/201005/01/20104After
Paul01/01/201005/01/20104After
     
     
What I need from the resident table In the table below.     
     
NameIdBefore_or After  
John1Before  
John2After  
Paul3Before  
Paul4After  
1 Reply