find the percentage completed based on two tables

[paulista]

I am new to qlikview and currently struggling to identify the below logic.

The first table contains values where event is batch submitted:

TABLE 1

EVT_TYPE	ID	TIMESTAMP	SUBJECT ID
collateral-valuation-batch-submitted	1	08/11/2019 12:53:48
collateral-valuation-batch-submitted	1	08/11/2019 12:54:10
collateral-valuation-batch-submitted	2	11/11/2019 14:13:06
collateral-valuation-batch-submitted	2	11/11/2019 14:13:31

then there is another table which contains the multiple PRPTY id related to ID .

TABLE 2

ID	PRPTY_ID
1	1000012827
1	1000012828
2	1000012829
2	1000012822

now i can see ID has two properties(PRPTY_ID's). i  want to check how many of these id'S out of total for that group of id have EVT_TYPE completed in table 1 at maximum timestamp 

PRPTY_ID in table 2= SUBJECT ID in table 1.

.basically i have to check the status of each id;s in batch .

thanks , please ask if i need to provide any more info.

[Brett_Bleess]

I will try to get you started here with a Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Peek-vs-Previous-When-to-Use-Each/ba-p/1475913

That is what you would need to do to look at each record to determine if it is still a member of the current ID etc.  There are multiple ways to go at it from there, and I am going to leave things for someone that is a much better developer than am I, but I wanted to get you something.  

If you want to do some further searching in the Design Blog area, use this URL:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are hundreds of mostly how-to posts in this area by our experts, so you should find some useful stuff there to give you ideas on on how to approach things.  Sorry I do not have anything better for you.

Regards,
Brett