Get max RowNo () for each value in a dimension

[nkosinde13]

Hi All

I need to get maximum row number for each value of a dimension. Not sure if this is possible?

I've attached an exported table I created on Qlikview.  The expression I used for row_no is =RowNo() which works perfectly fine but how then do I get a maximum row number for each value of dimension Team_Leader e.g. Max row number for Bethlehem Manager SE ect...?

Any help will be highly appreciated.

Thanks

Matlotlo

[sunny_talwar · Accepted solution]

May be try this

Count(DISTINT TOTAL <Team_Leader> SaleType1)

[nkosinde13]

Thank you so much Sunny, that's exactly what I was looking for 🙂