Unable to get the correct Row Number

[gopikrishnach]

Hi all,

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.

Add below expression.

=Aggr(RowNo(), WORKCENTER,IND)

[swuehl · Accepted solution]

If you are on a recent version of QV, try

=Aggr(Rowno(), WORKCENTER, (IND, (Text, ascending)) )

The sortable Aggr function is finally here!

Aggr() is sorting dimension values by load order by default, that's probably causing the differences you see.