topic Re: Unable to get the correct Row Number in QlikView https://community.qlik.com/t5/QlikView/Unable-to-get-the-correct-Row-Number/m-p/1241921#M868877 <HTML><HEAD></HEAD><BODY><P>If you are on a recent version of QV, try</P><P></P><P>=Aggr(Rowno(), WORKCENTER, (IND, (Text, ascending)) )</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4673">The sortable Aggr function is finally here!</A></P><P></P><P>Aggr() is sorting dimension values by load order by default, that's probably causing the differences you see.</P></BODY></HTML> Sat, 10 Dec 2016 22:37:46 GMT swuehl 2016-12-10T22:37:46Z Unable to get the correct Row Number https://community.qlik.com/t5/QlikView/Unable-to-get-the-correct-Row-Number/m-p/1241920#M868876 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>In qlikview, if i load partial data the row number is coming correctly where as if i load full data for one value the row number is showing different.</P><P></P><P>Add below expression.</P><P></P><P>=Aggr(RowNo(), WORKCENTER,IND)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-the-correct-Row-Number/m-p/1241920#M868876 gopikrishnach 2020-11-25T16:16:04Z Re: Unable to get the correct Row Number https://community.qlik.com/t5/QlikView/Unable-to-get-the-correct-Row-Number/m-p/1241921#M868877 <HTML><HEAD></HEAD><BODY><P>If you are on a recent version of QV, try</P><P></P><P>=Aggr(Rowno(), WORKCENTER, (IND, (Text, ascending)) )</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4673">The sortable Aggr function is finally here!</A></P><P></P><P>Aggr() is sorting dimension values by load order by default, that's probably causing the differences you see.</P></BODY></HTML> Sat, 10 Dec 2016 22:37:46 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-the-correct-Row-Number/m-p/1241921#M868877 swuehl 2016-12-10T22:37:46Z