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: 
GW2
Contributor
Contributor

Hi, i am a newbie - How to calculate average " yes" in a yes/no column?

What is an expression i need to use to find the average " yes" in a yes/no column?

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

=Count({<COLUMN_NAME_GOES_HERE={'yes'}>}COLUMN_NAME_GOES_HERE)/Count({<COLUMN_NAME_GOES_HERE={'yes','no'}>}COLUMN_NAME_GOES_HERE)

View solution in original post

3 Replies
jwjackso
Specialist III
Specialist III

If there values of [yes/no] are only 'yes' and 'no'

=Count({<[yes/no]={'yes'}>}[yes/no])/Count({<[yes/no]={'yes','no'}>}[yes/no])

or 

=Count({<[yes/no]={'yes'}>}[yes/no])/Count([yes/no])

GW2
Contributor
Contributor
Author

Thanks,  But where would i insert the column name?

jwjackso
Specialist III
Specialist III

=Count({<COLUMN_NAME_GOES_HERE={'yes'}>}COLUMN_NAME_GOES_HERE)/Count({<COLUMN_NAME_GOES_HERE={'yes','no'}>}COLUMN_NAME_GOES_HERE)