Count If Function

[#1]

Hi,

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

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.

[m_woolf]

Try:

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

Or:

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

[sunny_talwar · Accepted solution]

May be this

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