topic Re: COUNTIF in QlikView https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67479#M11129 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count({&lt;catID = {1}&gt;} catID)</STRONG></P></BODY></HTML> Wed, 21 Mar 2018 19:57:23 GMT sunny_talwar 2018-03-21T19:57:23Z COUNTIF https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67478#M11128 <HTML><HEAD></HEAD><BODY><P>I have a field, 'catID'</P><P></P><P>I want to write an expression that displays the number of times catID = "1"</P><P></P><P>I cannot seem to get my expression to work</P></BODY></HTML> Wed, 21 Mar 2018 19:55:55 GMT https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67478#M11128 evansabres 2018-03-21T19:55:55Z Re: COUNTIF https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67479#M11129 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count({&lt;catID = {1}&gt;} catID)</STRONG></P></BODY></HTML> Wed, 21 Mar 2018 19:57:23 GMT https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67479#M11129 sunny_talwar 2018-03-21T19:57:23Z Re: COUNTIF https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67480#M11130 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">count(<SPAN style="font-style: inherit; font-family: inherit;"><STRONG>distinct</STRONG></SPAN> {$&lt;[</SPAN><SPAN style="color: #636363; font-size: 13px; font-family: Arial;"><STRONG>catID</STRONG></SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">]={1}&gt;} </SPAN><SPAN style="font-size: 12px; font-family: Arial; color: #636363; background-color: #eef4f9;"><STRONG>catID</STRONG></SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</SPAN></P></BODY></HTML> Wed, 21 Mar 2018 19:58:19 GMT https://community.qlik.com/t5/QlikView/COUNTIF/m-p/67480#M11130 Chanty4u 2018-03-21T19:58:19Z