topic Re: Count If Function in App Development

Count If Function

Tue, 18 Apr 2017 17:29:37 GMT

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 — Tue, 18 Apr 2017 17:45:42 GMT

Try:

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

Or:

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

sunny_talwar — Tue, 18 Apr 2017 19:52:46 GMT

May be this

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