If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi allFor 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
These are the values of the flag
Can you provide some more information, what is id field in that table?
what is error you are getting with your expression?
If these are actual boolean values from Qlik, try checking on -1 which is the underlying value for true().
In regard to the hint from @Or to real boolean values it could be simplified with: