topic Re: Row Numbering in QlikView https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436059#M162636 <HTML><HEAD></HEAD><BODY><P>Thanks, that was close, I need this column as the first one in a straight table. Or, even if I could add in Caption total No. of rows in a resulting table that should be fine too.</P></BODY></HTML> Tue, 07 May 2013 18:05:55 GMT Anonymous 2013-05-07T18:05:55Z Row Numbering https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436057#M162634 <HTML><HEAD></HEAD><BODY><P>I've been looking for a built-in funtion that I could use at object-level for numbering of rows alwayd starting from 1 and increment by 1. For example:</P><P></P><P>No.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Retailer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category&nbsp;&nbsp;&nbsp;&nbsp; Prod&nbsp;&nbsp; Price</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cat1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19.99</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; T&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cat7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.99</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cat3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27.99</P><P></P><P>I need column No. all the time start from 1,2,3... for any selections.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 07 May 2013 17:41:57 GMT https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436057#M162634 Anonymous 2013-05-07T17:41:57Z Re: Row Numbering https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436058#M162635 <HTML><HEAD></HEAD><BODY><P>Use the rowno(total) as an expression. </P><P></P><P><EM>edit: In a straight table you can drag expressions to the left of any dimensions.</EM></P><P></P><P><EM>count(aggr(1,Dim1,Dim2,...,DimX)) will give you a count of the number of rows in an object with Dim1, Dim2,... and DimX as dimensions.<BR /></EM></P></BODY></HTML> Tue, 07 May 2013 17:43:07 GMT https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436058#M162635 Gysbert_Wassenaar 2013-05-07T17:43:07Z Re: Row Numbering https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436059#M162636 <HTML><HEAD></HEAD><BODY><P>Thanks, that was close, I need this column as the first one in a straight table. Or, even if I could add in Caption total No. of rows in a resulting table that should be fine too.</P></BODY></HTML> Tue, 07 May 2013 18:05:55 GMT https://community.qlik.com/t5/QlikView/Row-Numbering/m-p/436059#M162636 Anonymous 2013-05-07T18:05:55Z