topic Counting items in a Straight Table in QlikView https://community.qlik.com/t5/QlikView/Counting-items-in-a-Straight-Table/m-p/435391#M561205 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My Qlikview Document has a straight table, in which an expression exists that only shows data if the field <STRONG>level3desc_probcode</STRONG> = 'Maximo' or 'Syclo'.&nbsp; I then have 2 List Box, one which allows me to view Open or Closed Calls and the other which allows me to view just Maximo or just Syclo Calls.</P><P></P><P>However I need to do a count of the items in the Straight table and put it in a text object.&nbsp; However say there are 100 items in the field, 90 of them are Maximo 10 are Syclo.&nbsp; I need it so if I click the Maximo List Box, then the text objects shows as 90, and if I select the Syclo then the text object shows as 10.</P><P></P><P>Is this possible to do.</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Tue, 09 Apr 2013 10:54:49 GMT 2013-04-09T10:54:49Z Counting items in a Straight Table https://community.qlik.com/t5/QlikView/Counting-items-in-a-Straight-Table/m-p/435391#M561205 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My Qlikview Document has a straight table, in which an expression exists that only shows data if the field <STRONG>level3desc_probcode</STRONG> = 'Maximo' or 'Syclo'.&nbsp; I then have 2 List Box, one which allows me to view Open or Closed Calls and the other which allows me to view just Maximo or just Syclo Calls.</P><P></P><P>However I need to do a count of the items in the Straight table and put it in a text object.&nbsp; However say there are 100 items in the field, 90 of them are Maximo 10 are Syclo.&nbsp; I need it so if I click the Maximo List Box, then the text objects shows as 90, and if I select the Syclo then the text object shows as 10.</P><P></P><P>Is this possible to do.</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Tue, 09 Apr 2013 10:54:49 GMT https://community.qlik.com/t5/QlikView/Counting-items-in-a-Straight-Table/m-p/435391#M561205 2013-04-09T10:54:49Z Re: Counting items in a Straight Table https://community.qlik.com/t5/QlikView/Counting-items-in-a-Straight-Table/m-p/435392#M561206 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=Count(aggr(1, Dim1, Dim2, ..., DimN)). Replace Dim1 etc with the dimensions used in your straight table.</SPAN></P></BODY></HTML> Wed, 10 Apr 2013 13:55:52 GMT https://community.qlik.com/t5/QlikView/Counting-items-in-a-Straight-Table/m-p/435392#M561206 Gysbert_Wassenaar 2013-04-10T13:55:52Z