Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.