Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.