No, it does not work. Sorting is not possible anymore, sort settings are completely ignored, when you have a column with a formula "rowno(total)". The table itself is fine though.
Yes, I tried to put it as an expression. Putting it into the script does not work either, the value for the row number is empty after (reloading the script and) adding it to my table.
...the value for the row number is empty after (reloading the script and) adding it to my table.
It should work. Try RecNo() instead of RowNo() (in the script)?
From the help guide:
Counter Functions
These functions do not have any parameters. The parentheses are however still required.
RecNo( )
Returns an integer for the number of the currently read row of the internal table. The first record is number 1.
RowNo( )
Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is Concatenation to another. The first row is number 1.
Examples:
Raw data tables:
Tab1.csv
A
B
1
aa
2
cc
3
ee
Tab2.csv
A
B
5
xx
4
yy
6
zz
QVTab:
Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;
Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;
