Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: latest status of PID

Try to do this in script or front end?

Not applicable

Re: latest status of PID

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

Community Browser