RowNo works with the resulting internal Qlik Sense table after a load instead of the source table. This means that anything affecting the number of records loaded in a Load statement will also affect this function. For example, if my source table has 10 rows of data, but we then use a where condition that returns five rows, RowNo() will return numbers 1 to 5 while RecNo() will return values from 1 to 10 depending on the records returned.

The code shows in a simple way how RowNo() and RecNo() work:

MyData:
Load
  WeekDay,
    RecNo() AS RecNo,
    RowNo() As RowNo
Inline [
WeekDay
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
]
where WeekDay <> 'Tuesday';

The source table in the example contains 7 rows, however, the output contains 6 rows as we filter out Tuesday. The output after executing the scripts looks as follows: