Mastering Qlik Sense

RowNo

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 RowNoInline [WeekDayMondayTuesdayWednesdayThursdayFridaySaturdaySunday]where WeekDay <> 'Tuesday';

The source table in the example contains 7 rows, however, the output contains 6 rows as we ...