Discussion Board for collaboration related to QlikView App Development.
I have a table:
I do need this:
May be like this:
AutoNumber(RecNo(), Info) as Number
View solution in original post
Do you have any other solutions as this one increased the loading time dramatically?
I could live with this but I would like to be sure that this method is most efficient. Thanks.
Not sure if this is going to be any better, but this is the other option. If the data is already sorted, then you might not need to create FinalTable and should be able to create Number field within Table.
(html, codepage is 1252, embedded labels, table is @1);
If(Info = Previous(Info), RangeSum(Peek('Number'), 1), 1) as Number
Order By Info, Date;
DROP Table Table;
This solution works faster.
Did not know AutoNumber performed that poorly. Thanks for updating mindaugasbacius