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: 
Not applicable

Count Help Urgent...!!!

Hi Friends

Please check this table mentioned below:

Batch IdAssigned ToDate Assigned onReviewer AssignedStatusDocument Type
4992Team 112-02-2013Retwik Mukherjee CompletedOut of Scope
4993Team 112-02-2013Hage Oni CompletedOut of Scope
4994Team 112-02-2013Noshin AarifCompletedMSA  1992
4995Team 112-02-2013Sukanya BhattacharyyaCompletedAmd to MSA
4996Team 112-02-2013Retwik Mukherjee CompletedAmd to MSA
4997Team 112-02-2013Hage Oni CompletedMSA  1992
4998Team 112-02-2013Noshin AarifCompletedOut of Scope
4999Team 112-02-2013Sukanya BhattacharyyaCompletedOut of Scope
5000Team 112-02-2013Retwik Mukherjee CompletedNovation Agreement
5001Team 112-02-2013Hage Oni CompletedOut of Scope
5002Team 112-02-2013Noshin AarifCompletedNovation Agreement
5003Team 112-02-2013Sukanya BhattacharyyaCompletedAmd to MSA
5004Team 112-02-2013Retwik Mukherjee CompletedAmd to MSA
5005Team 112-02-2013Hage Oni CompletedOut of Scope
5006Team 112-02-2013Noshin AarifCompletedAmd to MSA
5007Team 112-02-2013Sukanya BhattacharyyaCompletedOut of Scope
5008Team 112-02-2013Retwik Mukherjee CompletedOut of Scope
5009Team 112-02-2013Retwik Mukherjee CompletedOut of Scope

I want to calculate count when status= Completed and  document type = Out of Scope w.r.t. to Team 1  

Please help me how to give the condition . I'm trying this condition count(if(status)='Completed' and if([document type])='Out of Scope')

but not getting any result....please help me out it's urgent...!!!

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Try using this

count(if(status='Completed'  and [document type]='Out of Scope',BatchId))

Regards

Amay

View solution in original post

3 Replies
Not applicable
Author

Hi,

Try using this

count(if(status='Completed'  and [document type]='Out of Scope',BatchId))

Regards

Amay

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this.

     Count({<Status = {"Completed"},Assigned_to = {"Team 1"},[Document Type] = {"Out of Scope"}>} Filed1)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Thanks Bro...!!!