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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

latest status of PID

Table1:

   

PIDNameStatusDateAID
1XXXOpen10/11/20141
1YYYClosed1/3/20153
1ZZZClosed12/1/20164
1MMM-19/1/20165

I have displayed the latest entry in Table2:

Table2:  

PIDNameStatusDateAID
1MMM-19/1/20165

I want to show the latest status of PID which is Closed on 12/1/2016 from Table1

Help me to get the below output

Output:

   

PIDNameStatusDateAID
1MMMClosed19/1/20165
2 Replies
sunny_talwar

Try to do this in script or front end?

Not applicable
Author

Yeah can I get any of it but i need output asap please