Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

2 Replies
johncaqc
Valued Contributor

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

Here's one solution...

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

Replace column_with_yes with your column/field name.

HTH,

John

MVP
MVP

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

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.

Community Browser