Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Contributor III
Contributor III

count boolean field

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 

aheavy95_0-1660813598484.png

 

Thanks 

Labels (3)
3 Replies
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

Great dreamer's dreams never fulfilled, they are always transcended.
Or
MVP
MVP

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
MVP & Luminary
MVP & Luminary

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

-sum(IsChatMissed)

- Marcus