topic Re: Sum the count of specific values in QlikView https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437442#M1162172 <HTML><HEAD></HEAD><BODY><P>So your original expression would be something like <STRONG>sum(if([Sensor Value]&gt;High or [Sensor Value]&lt;Low,[Sensor Value]))</STRONG> correct? Why can't you just replace "sum" with "count"?</P><P></P><P>Regards,</P><P>Vlad</P></BODY></HTML> Thu, 15 Nov 2012 20:51:56 GMT vgutkovsky 2012-11-15T20:51:56Z Sum the count of specific values https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437441#M1162171 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I would like to get the sum of counts of specific values.</P><P>Thus i would try to count the sum of values included in expression if([SensorValue]&gt;High or [SensorValue]&lt;Low).</P><P>Any ideas???</P></BODY></HTML> Thu, 15 Nov 2012 15:57:06 GMT https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437441#M1162171 2012-11-15T15:57:06Z Re: Sum the count of specific values https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437442#M1162172 <HTML><HEAD></HEAD><BODY><P>So your original expression would be something like <STRONG>sum(if([Sensor Value]&gt;High or [Sensor Value]&lt;Low,[Sensor Value]))</STRONG> correct? Why can't you just replace "sum" with "count"?</P><P></P><P>Regards,</P><P>Vlad</P></BODY></HTML> Thu, 15 Nov 2012 20:51:56 GMT https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437442#M1162172 vgutkovsky 2012-11-15T20:51:56Z Re: Sum the count of specific values https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437443#M1162173 <HTML><HEAD></HEAD><BODY><P>Do you have a sample file of what you are trying to do?</P></BODY></HTML> Thu, 15 Nov 2012 20:52:02 GMT https://community.qlik.com/t5/QlikView/Sum-the-count-of-specific-values/m-p/437443#M1162173 2012-11-15T20:52:02Z