How do I count the number of times that "yes" is appears in a column?

[#1]

How do I count the number of times that "yes" is appears in a column?

[johnca]

Here's one solution...

Sum(If(column_with_yes='yes',1,0))

Replace column_with_yes with your column/field name.

HTH,

John

[jagan]

Hi Bob,

Try like this

Count({<DimensionName={'yes'}>} DimensionName)

OR

If you have any primary key field then use this expression.

Count({<DimensionName={'yes'}>} Distinct KeyDimensionName)

Note: Qlikview is case sensitive so give correct 'yes' or 'Yes' or 'YES'.

     Replace DimensionName or KeyDimensionName with your actual column names.

Hope this helps you.

Regards,

jagan.