How to count "Yes" from the cells in different column?

[#1]

Hello guys I need a little help.

I have this example table:

User	Facebook	Linkedin	Twitter	Instagram
A	Yes	Yes	No	No
B	Yes	Yes	Yes	Yes
C	No	Yes	No	Yes
D	Yes	No	Yes	No

How can I count "Yes" from this four different columns?

[MarcoWedel]

Please close your thread if your initial question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[vishsaggi]

Did you try adding User as your Dimension?

[shizia_mirza]

I've been trying to find a way where you can count values across the columns - so using the original example is there a way to count how many users have selected 'Yes' for all four platforms?

[#5]

I try and works but I don't want to show wich user have or not facebook for example. I need just to show the amount of users who have and the amount who doesn't have.

[vishsaggi]

Is this something you are looking for? If yes, just follow the Sunny's script and use Platform as your dimension and count() as your expression.

Expr1: = Count({<Response = {'Yes'}>} Response)

Expr2: = Count({<Response -= {'Yes'}>} Response)