Qlik Community

Qlik Sense App Development

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

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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)

View solution in original post

2 Replies
Highlighted
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)

View solution in original post