Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
johnca
Specialist
Specialist

Here's one solution...

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

Replace column_with_yes with your column/field name.

HTH,

John

jagan
Partner - Champion III
Partner - Champion III

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.