topic Re: Count in QlikView https://community.qlik.com/t5/QlikView/Count/m-p/513411#M552484 <HTML><HEAD></HEAD><BODY><P>Count(If(Core &lt; 4 and hardware = 'new' and Server = 'Wintel', NameofFieldYou wantToCount))</P><P></P><P>Sum(If(Core &lt; 4 and hardware = 'new' and Server = 'Wintel', NameofFieldYou wantToSum))</P></BODY></HTML> Fri, 04 Oct 2013 15:06:18 GMT jpapador 2013-10-04T15:06:18Z Count https://community.qlik.com/t5/QlikView/Count/m-p/513410#M552483 <HTML><HEAD></HEAD><BODY><P>hi there, </P><P>can you please put this in a statement for me</P><P></P><P>1 - Count - if Core&lt;4 and hardware=new and Server=Wintel</P><P>2 - SUM - if Core&lt;4 and hardware=new and Server=Wintel</P></BODY></HTML> Fri, 04 Oct 2013 15:04:41 GMT https://community.qlik.com/t5/QlikView/Count/m-p/513410#M552483 2013-10-04T15:04:41Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/513411#M552484 <HTML><HEAD></HEAD><BODY><P>Count(If(Core &lt; 4 and hardware = 'new' and Server = 'Wintel', NameofFieldYou wantToCount))</P><P></P><P>Sum(If(Core &lt; 4 and hardware = 'new' and Server = 'Wintel', NameofFieldYou wantToSum))</P></BODY></HTML> Fri, 04 Oct 2013 15:06:18 GMT https://community.qlik.com/t5/QlikView/Count/m-p/513411#M552484 jpapador 2013-10-04T15:06:18Z