topic Re: Get max RowNo () for each value in a dimension in QlikView https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128042#M758834 <HTML><HEAD></HEAD><BODY><P>Thank you so much Sunny, that's exactly what I was looking for <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 28 Aug 2018 13:06:49 GMT nkosinde13 2018-08-28T13:06:49Z Get max RowNo () for each value in a dimension https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128040#M758832 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P>I need to get maximum row number for each value of a dimension. Not sure if this is possible?</P><P>I've attached an exported table I created on Qlikview.&nbsp; The expression I used for row_no is <STRONG>=RowNo() </STRONG>which works perfectly fine but how then do I get a maximum row number for each value of dimension <STRONG>Team_Leader</STRONG> e.g. Max row number for <STRONG>Bethlehem Manager SE ect...?</STRONG></P><P></P><P>Any help will be highly appreciated.</P><P><STRONG><BR /></STRONG></P><P>Thanks</P><P>Matlotlo</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128040#M758832 nkosinde13 2020-11-25T16:16:04Z Re: Get max RowNo () for each value in a dimension https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128041#M758833 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Count(DISTINT TOTAL &lt;Team_Leader&gt; SaleType1)</STRONG></P></BODY></HTML> Tue, 28 Aug 2018 12:52:35 GMT https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128041#M758833 sunny_talwar 2018-08-28T12:52:35Z Re: Get max RowNo () for each value in a dimension https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128042#M758834 <HTML><HEAD></HEAD><BODY><P>Thank you so much Sunny, that's exactly what I was looking for <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 28 Aug 2018 13:06:49 GMT https://community.qlik.com/t5/QlikView/Get-max-RowNo-for-each-value-in-a-dimension/m-p/128042#M758834 nkosinde13 2018-08-28T13:06:49Z