count boolean field

[aheavy95]

Hi all
For a KPI, I need to count the number of occasions when a certain flag (boolean field) equlas "true"

I tried this formula, I get an "OK" in the expression window, but there is still an error with the expression

=count({<IsChatMissed={"True"}>}IsChatMissed) 

These are the values of the flag 

Thanks 

[PrashantSangle]

Can you provide some more information, what is id field in that table?

what is error you are getting with your expression?

Regards,

Prashant Sangle

[Or]

If these are actual boolean values from Qlik, try checking on -1 which is the underlying value for true().

=count({<IsChatMissed={'-1'}>}IsChatMissed)

[marcus_sommer]

In regard to the hint from @Or to real boolean values it could be simplified with:

-sum(IsChatMissed)

- Marcus