topic How to Count a field with a certain expression applied in QlikView https://community.qlik.com/t5/QlikView/How-to-Count-a-field-with-a-certain-expression-applied/m-p/150627#M28612 <HTML><HEAD></HEAD><BODY><P>Hey All,<BR /> I created an expression:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">if((Count ( {&lt; Dateentered = {'06/2009'}&gt;} Service) - Count ( {&lt; Dateentered = {'05/2009'} &gt;} Service)) &lt; 0 ) , 'Green', 'red')</PRE><BR /><BR /> <P>What the expression does is it subtracts the count of services this month and the prior month and if it is less then 0 then green else it is red. What I would like to do is count how many of the services are green, but I am unsure how to even begin. I tried just counting the expression but I get a -. Any thoughts?</P></BODY></HTML> Wed, 29 Jul 2009 22:05:38 GMT 2009-07-29T22:05:38Z How to Count a field with a certain expression applied https://community.qlik.com/t5/QlikView/How-to-Count-a-field-with-a-certain-expression-applied/m-p/150627#M28612 <HTML><HEAD></HEAD><BODY><P>Hey All,<BR /> I created an expression:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">if((Count ( {&lt; Dateentered = {'06/2009'}&gt;} Service) - Count ( {&lt; Dateentered = {'05/2009'} &gt;} Service)) &lt; 0 ) , 'Green', 'red')</PRE><BR /><BR /> <P>What the expression does is it subtracts the count of services this month and the prior month and if it is less then 0 then green else it is red. What I would like to do is count how many of the services are green, but I am unsure how to even begin. I tried just counting the expression but I get a -. Any thoughts?</P></BODY></HTML> Wed, 29 Jul 2009 22:05:38 GMT https://community.qlik.com/t5/QlikView/How-to-Count-a-field-with-a-certain-expression-applied/m-p/150627#M28612 2009-07-29T22:05:38Z How to Count a field with a certain expression applied https://community.qlik.com/t5/QlikView/How-to-Count-a-field-with-a-certain-expression-applied/m-p/150628#M28613 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>just an idea.</P><P>See the attached application.</P><P>Rainer</P></BODY></HTML> Thu, 30 Jul 2009 14:34:17 GMT https://community.qlik.com/t5/QlikView/How-to-Count-a-field-with-a-certain-expression-applied/m-p/150628#M28613 2009-07-30T14:34:17Z