topic Re: How to count Y/N data in fields? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791255#M1026373 <HTML><HEAD></HEAD><BODY><P>Thanks a lot to both of you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Mar 2015 11:16:16 GMT 2015-03-12T11:16:16Z How to count Y/N data in fields? https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791252#M1026370 <HTML><HEAD></HEAD><BODY><P>Hi, what is the formula to apply in a chart to count Y/N data in fields?</P><P></P><P>For example, I have as a field "email received" and then Y or N as data.</P><P></P><P>When in my chart I use the formula Count(received) I have the number of emails received but I would like to have only the ones who are marked "Y".</P><P></P><P>I tried Count(RECEIVED) = 'Y' but it doesn't work...</P><P></P><P>Help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Mar 2015 11:08:02 GMT https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791252#M1026370 2015-03-12T11:08:02Z Re: How to count Y/N data in fields? https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791253#M1026371 <HTML><HEAD></HEAD><BODY><P>count({&lt;<SPAN style="font-size: 13.3333330154419px;">RECEIVED={'Y'}</SPAN>&gt;}RECEIVED)</P></BODY></HTML> Thu, 12 Mar 2015 11:08:54 GMT https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791253#M1026371 Gysbert_Wassenaar 2015-03-12T11:08:54Z Re: How to count Y/N data in fields? https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791254#M1026372 <HTML><HEAD></HEAD><BODY><P>For counting Y's you can use this:</P><P></P><P><STRONG>=Count({&lt;RECEIVED = {'Y'}&gt;} RECEIVED)</STRONG></P><P></P><P>HTH</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Thu, 12 Mar 2015 11:09:36 GMT https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791254#M1026372 sunny_talwar 2015-03-12T11:09:36Z Re: How to count Y/N data in fields? https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791255#M1026373 <HTML><HEAD></HEAD><BODY><P>Thanks a lot to both of you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Mar 2015 11:16:16 GMT https://community.qlik.com/t5/QlikView/How-to-count-Y-N-data-in-fields/m-p/791255#M1026373 2015-03-12T11:16:16Z