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: 
keithericparsons77
Contributor II
Contributor II

COUNT IF two conditions

Good morning, I am having trouble writing a formula for a "Count if" of 2 conditions.

I have 2 columns of data, one with a [Shop Code], one with [Check Type].

I am trying to write a formula like:

  "if [shop code] = '84100',  and  [check type] = 'accept',  count 'accept' of '84100'.

 

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

You want to use set analysis, like this:

count({$<[shop code]={'84100'},[check type]={'accept'}>} [shop code])

Not sure if there is another field you want to use as the count field.  I just used [shop code] as an example.

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

You want to use set analysis, like this:

count({$<[shop code]={'84100'},[check type]={'accept'}>} [shop code])

Not sure if there is another field you want to use as the count field.  I just used [shop code] as an example.

keithericparsons77
Contributor II
Contributor II
Author

thanks for the help.  Much appreciated.  this worked.

kp