Expression to filter on two conditions where duplicates contain different results

[tastydew]

Hello everyone,

In my data, I have the following scenario:

Req #	Status
1428	Completed
1365	Completed
1428	Error
1428	Completed
1365	Error

In my analysis, I want to show a count of Req # where there are more than 2 and their Status count of "Completed" is more than 1.. I've attempted using nested If statements, but my results do not show what I am looking for.

If (If(Count([Req #])>1,Count([Req #]))>2 and Count(Status='Completed')>1,[Status])

So my results should be:

Req #	Completed
1428	2

Is there a better way (or rather the correct way) to handle this?

[bharathadde]

Please find the attachment, hope it will help you

[tastydew]

Sorry, I dont have access to Qlik Desktop... Only Qlik Sense Hub

[bharathadde]

Create a pivot table using below

Dimension 1: Req

Dimension 2: =if(Status='Completed',Status)

Expression : =if(Count(Total <Req> Status = 'Completed')>2 and Status = 'Completed',Count({<Status={'Completed'}>}Total <Req> Status))