Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

find the percentage completed based on two tables

 

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_TYPEIDTIMESTAMPSUBJECT ID
collateral-valuation-batch-submitted108/11/2019 12:53:48 
collateral-valuation-batch-submitted108/11/2019 12:54:10 
collateral-valuation-batch-submitted211/11/2019 14:13:06 
collateral-valuation-batch-submitted211/11/2019 14:13:31 

 

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

TABLE 2

IDPRPTY_ID 
11000012827

 
11000012828 
21000012829 
21000012822 

 

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.

 

 

 

 

 

 

 

Labels (2)
1 Reply
Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.