Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
A7R3
Contributor III
Contributor III

Straight Table - Display the correct row by status

Hi,

I have a situation that I have many product reports with different timestamps. For illustration, the product table will look like this

ProductsReportDateStatusProgress
A1/1/2021090%
A2/1/20211100%
A3/1/2021080%
B1/1/2021090%
B2/1/2021070%
B3/1/2021090%

 

I would like to create a summary report with the following rules:

IF the Product has achieved the status = 1, shows the corresponding ReportDate and Progress. (Ignore the latest ReportDate)
IF the Product hasn't achieved the status = 1 (all Status = 0), shows  the latest ReportDate and Progress. (Ignore the earlier ReportDate)

The result should look like this

ProductsReportDateStatusProgress
A2/1/20211100%
B3/1/2021090%

 

Appreciate any advice on this. Thanks in advance.

 

      

Labels (2)
1 Solution

Accepted Solutions
A7R3
Contributor III
Contributor III
Author

I manage to solve the problem with IF/Match statement to show the correct rows. Thank you for those who are looking out for this.

View solution in original post

2 Replies
A7R3
Contributor III
Contributor III
Author

One thing to mention is that the Progress field is linked to Product field and ReportDate field. So the filter must return the correct ReportDate so that the corresponding Progress will show up correctly.

A7R3
Contributor III
Contributor III
Author

I manage to solve the problem with IF/Match statement to show the correct rows. Thank you for those who are looking out for this.