topic Counting number of rows in QlikView https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736487#M1084096 <HTML><HEAD></HEAD><BODY><P>Hi, i have a simple chart - straight table, and in a text box above i want to show number of rows in this table. Is there any way to do this ?</P></BODY></HTML> Tue, 24 Jun 2014 13:51:12 GMT 2014-06-24T13:51:12Z Counting number of rows https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736487#M1084096 <HTML><HEAD></HEAD><BODY><P>Hi, i have a simple chart - straight table, and in a text box above i want to show number of rows in this table. Is there any way to do this ?</P></BODY></HTML> Tue, 24 Jun 2014 13:51:12 GMT https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736487#M1084096 2014-06-24T13:51:12Z Re: Counting number of rows https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736488#M1084097 <HTML><HEAD></HEAD><BODY><P>it is possible in the caption of your table, simply doing Count(myfield) where myfield is a field in your table</P></BODY></HTML> Tue, 24 Jun 2014 13:59:00 GMT https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736488#M1084097 alexandros17 2014-06-24T13:59:00Z Re: Counting number of rows https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736489#M1084098 <HTML><HEAD></HEAD><BODY><P>Try =sum(aggr(1,Dim1,Dim2,...,DimN)) where Dim1,Dim2,...,DimN are the dimensions of your straight table. This doesn't always work correctly. If you suppress values in the straight table, for example with set analysis, then the count can be off.</P></BODY></HTML> Tue, 24 Jun 2014 13:59:42 GMT https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736489#M1084098 Gysbert_Wassenaar 2014-06-24T13:59:42Z Re: Counting number of rows https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736490#M1084099 <HTML><HEAD></HEAD><BODY><P>how many dimensions do you have. Mostly in the st table based on the dimension you will have the number of records. you can create a text object to count the Distinct Dimension field values.</P></BODY></HTML> Tue, 24 Jun 2014 14:00:19 GMT https://community.qlik.com/t5/QlikView/Counting-number-of-rows/m-p/736490#M1084099 sudeepkm 2014-06-24T14:00:19Z