Using RowNo() with Section Access

[waleeed_mahmood]

Hello all,

I am reading in few records/rows from the database into QS and then applying section access on them. I have a field which shows the RecNo() and a field which shows the RowNo() in a table. My issue is that when i use RowNo() in qlik, it returns the rowID of the rows that were loaded from the DB. i want the rowID of the rows that are in the table after the Section access in applied. Below are some pictures to illustrate my point.

Figure 1:

 The column in green is the rowID of the records that are read from the DB. I want to get the rowID of the rows currently in the table. So, excluding those that were taken out by the section access.

The desired result would be:

Rec No	Row No
2	1
3	2
6	3
7	4
10	5
11	6
14	7
15	8
18	9
19	10

Please let me know if you need more information.

Thank you.

[marcus_sommer]

I think it's not possible. The data reduction from the section access isn't applied during the reload else it happens by opening the application. Therefore you will need to apply such a logic within the UI - maybe just with rank(ROWNO) or similar.

- Marcus