Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tastydew
New Contributor

Expression to filter on two conditions where duplicates contain different results

Hello everyone,

In my data, I have the following scenario:

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

 

 

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
14282

 

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

3 Replies
bharathadde
Contributor II

Re: Expression to filter on two conditions where duplicates contain different results

Please find the attachment, hope it will help you

Highlighted
tastydew
New Contributor

Re: Expression to filter on two conditions where duplicates contain different results

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

Re: Expression to filter on two conditions where duplicates contain different results

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))