Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
waleeed_mahmood
Creator
Creator

Using RowNo() with Section Access

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:

RowsWithSA.PNG 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 NoRow No
21
32
63
74
105
116
147
158
189
1910

 

Please let me know if you need more information.

Thank you.

Labels (4)
1 Reply
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