Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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