topic Re: Total number of rows in a straight table in QlikView https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152387#M376404 <HTML><HEAD></HEAD><BODY><P>When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others</P></BODY></HTML> Wed, 28 Feb 2018 09:04:29 GMT pablolabbe 2018-02-28T09:04:29Z Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152379#M376396 <HTML><HEAD></HEAD><BODY><P>I have a straight table with 24 columns and has around 20 dimensions in it. </P><P>I need to display the number of rows in the straight table in the table header. </P><P>I have already tired the below </P><P>count(distinct(dim1&amp;dim2...))</P><P>rowno()</P><P>rowno(total)</P><P>count(expresion1)</P><P></P><P>Nothing works.... I could see the task bar of qlikview displaying the number of rows and colums when the mouse roll over the straight table. Is there a way to get that value in to the expression or can anyone suggest a method to display the number of rows in straight table</P></BODY></HTML> Wed, 08 Jun 2016 14:11:19 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152379#M376396 Anonymous 2016-06-08T14:11:19Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152380#M376397 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Count(Aggr(RowNo(TOTAL), ListofYour20DimensionsHere))</STRONG></P></BODY></HTML> Wed, 08 Jun 2016 15:46:31 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152380#M376397 sunny_talwar 2016-06-08T15:46:31Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152381#M376398 <HTML><HEAD></HEAD><BODY><P>Thanks for this</P></BODY></HTML> Thu, 15 Feb 2018 09:42:53 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152381#M376398 YoussefBelloum 2018-02-15T09:42:53Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152382#M376399 <HTML><HEAD></HEAD><BODY><P>Nice one</P></BODY></HTML> Thu, 15 Feb 2018 10:56:35 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152382#M376399 shiveshsingh 2018-02-15T10:56:35Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152383#M376400 <HTML><HEAD></HEAD><BODY><P>Is there any way to count the no of records rather than specifying the list of all dimensions</P></BODY></HTML> Tue, 27 Feb 2018 11:13:34 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152383#M376400 mukesh19 2018-02-27T11:13:34Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152384#M376401 <HTML><HEAD></HEAD><BODY><P>Not sure I understand your question. Would you be able to elaborate?</P></BODY></HTML> Tue, 27 Feb 2018 12:05:35 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152384#M376401 sunny_talwar 2018-02-27T12:05:35Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152385#M376402 <HTML><HEAD></HEAD><BODY><P>Instead of specifying all the 20 dimensions, is there any other alternative?</P></BODY></HTML> Tue, 27 Feb 2018 12:18:27 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152385#M376402 mukesh19 2018-02-27T12:18:27Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152386#M376403 <HTML><HEAD></HEAD><BODY><P>There might be... will depend on your dimensions, expressions and other chart properties</P></BODY></HTML> Tue, 27 Feb 2018 12:19:56 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152386#M376403 sunny_talwar 2018-02-27T12:19:56Z Re: Total number of rows in a straight table https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152387#M376404 <HTML><HEAD></HEAD><BODY><P>When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others</P></BODY></HTML> Wed, 28 Feb 2018 09:04:29 GMT https://community.qlik.com/t5/QlikView/Total-number-of-rows-in-a-straight-table/m-p/1152387#M376404 pablolabbe 2018-02-28T09:04:29Z