topic Re: Count assistance in QlikView https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051515#M352901 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(field1</SPAN><SPAN style="font-size: 8pt;">)='YES')+ (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(field2)</SPAN><SPAN style="font-size: 8pt;">='NO'))) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">will this work?</SPAN></P></BODY></HTML> Mon, 18 Apr 2016 16:23:33 GMT 2016-04-18T16:23:33Z Count assistance https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051513#M352899 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P style="margin: 0px 0px 0px 1in;"></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><UL><LI>Count all entries that meet the criteria <STRONG><SPAN style="color: #3366ff;">FIELD1</SPAN><SPAN style="color: #0070c0;"><EM> </EM></SPAN></STRONG><EM>with answer<STRONG> <SPAN style="color: #00b050;">‘YES’ </SPAN></STRONG>and</EM> <SPAN style="color: #0070c0;"><STRONG>FIELD2</STRONG></SPAN><EM> <EM>with answer<STRONG> <SPAN style="color: #00b050;">‘NO’ </SPAN></STRONG></EM>&lt;<SPAN style="color: red;">Note** that this combination will be the argument we use to identify all COMP that were flown by a drone</SPAN>&gt;</EM> TAKE OUT NULLS.<UL style="list-style-type: circle;"><LI style="color: #000000; font-family: 'Calibri',sans-serif; font-size: 11pt; font-style: normal; font-weight: normal;"><P style="color: #000000; font-family: 'Calibri',sans-serif; font-size: 11pt; font-style: normal; font-weight: normal; margin-top: 0in; margin-bottom: 8pt; mso-add-space: auto; mso-list: l0 level2 lfo1;"><EM>Display total count</EM></P></LI></UL></LI></UL><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp;&nbsp; </SPAN></P></BODY></HTML> Mon, 18 Apr 2016 16:14:12 GMT https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051513#M352899 2016-04-18T16:14:12Z Re: Count assistance https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051514#M352900 <HTML><HEAD></HEAD><BODY><P>Not sure, but maybe</P><P></P><P>=Count( {&lt;FIELD1 = {'YES'}, FIELD2 = {'NO'} &gt;} YourCountEntryField)</P></BODY></HTML> Mon, 18 Apr 2016 16:16:26 GMT https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051514#M352900 swuehl 2016-04-18T16:16:26Z Re: Count assistance https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051515#M352901 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(field1</SPAN><SPAN style="font-size: 8pt;">)='YES')+ (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(field2)</SPAN><SPAN style="font-size: 8pt;">='NO'))) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">will this work?</SPAN></P></BODY></HTML> Mon, 18 Apr 2016 16:23:33 GMT https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051515#M352901 2016-04-18T16:23:33Z Re: Count assistance https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051516#M352902 <HTML><HEAD></HEAD><BODY><P>Does it work? I believe it won't return a total count of your field(s), but if you think that this is the correct answer...</P></BODY></HTML> Mon, 18 Apr 2016 16:26:18 GMT https://community.qlik.com/t5/QlikView/Count-assistance/m-p/1051516#M352902 swuehl 2016-04-18T16:26:18Z