Count of 0 in expression

[Paknanarn23]

I want to count only 0's in each Job_Order. I've tried this code, but the output value Some are right and some are wrong.

Count(TOTAL <StartTime> {<ParamName={'COUNTER'},Value = {'0'}>} WorkOrderNo)

I give an example in this Job_Order , I can count in excel all 4 but in Qlikview count 8 , what should I do ?

Excel

Qlikview

[Mark_Little]

Hi Try,

COUNT(IF(COUNTER=0,1,0))

[Paknanarn23]

I've used the code you suggested. Value came out too much I want to count 0 in each WO.

[Paknanarn23 · Accepted solution]

Count(DISTINCT{$<Counter = {0}>}[Time_Stamp])