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 If Function

Hi,

I'm new to Qlik and could use some help. I have a table structured below as such:

cool.PNG

I'm trying to write a statement that will give me the total number of machines where the Program = 'DETECT STOP'. So the answer should equal 2.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT {<Program = {'DETECT STOP'}>} MachineNumber)

View solution in original post

2 Replies
m_woolf
Master II
Master II

Try:

=COUNT(IF(Gender='Male',ID))


Or:

=COUNT({<Gender={'Male'}>} ID)

sunny_talwar

May be this

Count(DISTINCT {<Program = {'DETECT STOP'}>} MachineNumber)