topic Re: Nested Count If statement in expression help in QlikView https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10989#M790129 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P></P><P><STRONG>Count({&lt;Annual -= {"Complete"}&gt;} Annual)</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 16:32:49 GMT Anil_Babu_Samineni 2018-02-12T16:32:49Z Nested Count If statement in expression help https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10988#M790128 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Annual</STRONG></TH></TR><TR><TD style="padding: 2px;">Backup</TD></TR><TR><TD style="padding: 2px;">Complete</TD></TR><TR><TD style="padding: 2px;">Owner</TD></TR></TBODY></TABLE><P></P><P>I have a pivot table with columns similar to the above. I would like to do another chart that only counts cells that do not show as&nbsp; "Complete". I tried the below formula but its not working, does anyone have any suggestions?</P><P></P><P>If(([Annual] &lt;&gt; 'Complete'),Count[Annual], Null())</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10988#M790128 Anonymous 2020-11-25T16:16:04Z Re: Nested Count If statement in expression help https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10989#M790129 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P></P><P><STRONG>Count({&lt;Annual -= {"Complete"}&gt;} Annual)</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 16:32:49 GMT https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10989#M790129 Anil_Babu_Samineni 2018-02-12T16:32:49Z Re: Nested Count If statement in expression help https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10990#M790130 <HTML><HEAD></HEAD><BODY><P>doesnt the field have to be in brackets "[]" it doesnt pick it up otherwise for me</P></BODY></HTML> Mon, 12 Feb 2018 16:38:01 GMT https://community.qlik.com/t5/QlikView/Nested-Count-If-statement-in-expression-help/m-p/10990#M790130 Anonymous 2018-02-12T16:38:01Z