Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Count If Function

May be this

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

2 Replies
mwoolf
Honored Contributor II

Re: Count If Function

Try:

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


Or:

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

Re: Count If Function

May be this

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

Community Browser