Count value when field equals. Need Assistance

[#1]

Need assistance with the following query

We have a table with a single column, field name "Answered" with values True and False

Answered

True

True

False

False

True

We need to count the True values ?  I've tried the following but it returns zero.. Not sure what I'm missing?

Count({<Answered={"True"}>} Answered)

[alexandros17]

It should work ... try to cancel all selections in the document ...

Could you send me your document?

[#3]

Will  send later tonight. Many thanks 

Sent from my Samsung Galaxy smartphone.

[jagan]

Hi,

This expression

=Count({<Answered={'True'}>} Answered)

Should work, check whether True has any blank space in it or try clearing the selections.

Regards,

Jagan.

[Kushal_Chawda]

try this

=Count(if(lower(trim(Answered))='trim',Answered))

[#6]

[#7]

We have some data from phone reporting, Date field, Call ID,  Answered (True or False)

I'm then using Qlik to count the total number of calls per day - which works fine count

Im using a table then adding my date field as my Dimension and using the measure  Count([Caller ID])

Which is fine, I then want to add a third column to the table to count the number of "True" answered calls

I attempted this by adding a third column to the table and selecting measure using the expression as below:

=Count({<Answered={'True'}>} Answered)

!

[#8]

I've attached the QVF file for reference - thanks

[#9]

I've attached my qvf file for reference see other response thanks for your assistance

[robert_mika]

Please see attached.

It is working