topic Re: Count only numeric codes in QlikView https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427710#M159386 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>=sum( if (isnum(ITEMID), QTY))</P></BODY></HTML> Wed, 16 Jan 2013 15:23:44 GMT swuehl 2013-01-16T15:23:44Z Count only numeric codes https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427709#M159385 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the salesline table, where I have all my sales. there I have itemid and quantity.</P><P></P><P>I would like to make a Sum from all the quantities but only from the itemid numeric.</P><P></P><P>ITEMID&nbsp;&nbsp;&nbsp;&nbsp; QTY</P><P></P><P>11111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>12SSS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>22222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P></P><P>The formula should result: 4</P><P></P><P>Could somebody help to me?</P><P>=num(Sum({&lt;[ITEMID]={'A-Z'}&gt;} QTY),'#.###,')</P><P></P><P>thank's</P><P>Eduard</P></BODY></HTML> Wed, 16 Jan 2013 15:18:14 GMT https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427709#M159385 ecabanas 2013-01-16T15:18:14Z Re: Count only numeric codes https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427710#M159386 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>=sum( if (isnum(ITEMID), QTY))</P></BODY></HTML> Wed, 16 Jan 2013 15:23:44 GMT https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427710#M159386 swuehl 2013-01-16T15:23:44Z Re: Count only numeric codes https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427711#M159387 <HTML><HEAD></HEAD><BODY><P>it works!!!! thank's</P><P></P><P></P><P>Eduard</P></BODY></HTML> Wed, 16 Jan 2013 15:44:39 GMT https://community.qlik.com/t5/QlikView/Count-only-numeric-codes/m-p/427711#M159387 ecabanas 2013-01-16T15:44:39Z