Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Count(DISTINCT {<Program = {'DETECT STOP'}>} MachineNumber)
Try:
=COUNT(IF(Gender='Male',ID))
Or:
=COUNT({<Gender={'Male'}>} ID)
May be this
Count(DISTINCT {<Program = {'DETECT STOP'}>} MachineNumber)