Display top 11 to 20 rows in Qlik Sense straight table

[QS_]

I want to display the top 20 rows split into two straight tables. My table has only one dimension column. The rest are all measure columns. The Top N is calculated on the first measure column.

The first table should show the Top 10 rows. I've achieved this by setting the limitation to a fixed number and entering a value of 10. I want the second table to show the subsequent 10 rows, i.e. 11 to 20. I tried implementing this with the following formula :

If(Match(RowNo(), 11,12,13,14,15,16,17,18,19,20), DimensionField)

It doesn't work for this table. But this worked formula worked for me when I used it on a table with dimensions only.

I would appreciate any help in solving this issue.

[BrunPierre · Accepted solution]

Perhaps something like this while suppressing null

=If(
Aggr(Rank(Measure), Dimension) > 10
and Aggr(Rank(Measure), Dimension) <= 20,
Dimension
)

[QS_]

Thank you for the solution! This worked exactly as per my requirement.