Solved: Range of values from a list - Page 2

Stelio_Pappas · 07-27-2021 04:41 PM

Hi all,

Does anyone know a technique for extracting a range of values from a sorted list of variable length?

I can already get the TOP() 10 values, but I need to get the next range. Eg I need to get values 11 to 20.

My apologies for asking this twice. -I suspect I tagged and worded my first question poorly.

Thanks in advance
Stel

Suvrutt_Gurjar

Hi @Stelio_Pappas ,

You could try the below expression

TOP ( [SortedList]- (TOP ( [SortedList] , [From]-1) ), [To] - [From]+1)

[SortedList] is list of sorted text elements. [From] and [To] are number type columns defining the range. I tested the expression on text elements list, even though it should typically work on lists of other elements as well.

View solution in original post