topic Re: How to exclude value from field in expression Count in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808361#M2655 <HTML><HEAD></HEAD><BODY><P>This should work:<BR />=count({&lt;report-={'N/A'}&gt;} report)</P></BODY></HTML> Mon, 02 Feb 2015 17:27:26 GMT Anonymous 2015-02-02T17:27:26Z How to exclude value from field in expression Count https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808360#M2654 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P><BR />In a chart expression how can I exclude the value 'n/a' from the report field when doing a count? I only want to count values that are not 'N/A' for Report.</P><P></P><P>Count(report)</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Mon, 02 Feb 2015 17:19:50 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808360#M2654 2015-02-02T17:19:50Z Re: How to exclude value from field in expression Count https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808361#M2655 <HTML><HEAD></HEAD><BODY><P>This should work:<BR />=count({&lt;report-={'N/A'}&gt;} report)</P></BODY></HTML> Mon, 02 Feb 2015 17:27:26 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808361#M2655 Anonymous 2015-02-02T17:27:26Z Re: How to exclude value from field in expression Count https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808362#M2656 <HTML><HEAD></HEAD><BODY><P>count({$ &lt;Report-={N/A}&gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Report</SPAN>)</P></BODY></HTML> Mon, 02 Feb 2015 17:31:09 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-exclude-value-from-field-in-expression-Count/m-p/808362#M2656 maxgro 2015-02-02T17:31:09Z