Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Count(DISTINT TOTAL <Team_Leader> SaleType1)
Thank you so much Sunny, that's exactly what I was looking for 🙂