Rank in load script (with partition by)

Ania — Wed, 24 Mar 2021 07:24:51 GMT

Hi,

I need to rank results in the same way as a rank function does in sql server:

I've already tried:

AutoNumber(RowNo(),Platform) as Rank
AutoNumber(Value,Platform) as Rank
if(Platform= Previous(Platform), Peek(Rank) + 1, 1) as Rank
If(Platform= Previous(Platform) and Value= peek(Value), Peek(Rank), if( Platform= Previous(Platform), Peek(Rank) + 1, 1)) as Rank

with order by Platform, Value

Is there a way to do this in QlikView?

Re: Rank in load script (with partition by)

Ania — Wed, 24 Mar 2021 07:36:16 GMT

I managed to do it:

LOAD *,
If(Platform= Previous(Platform) and Value= peek(Value), Peek(Rank), RowNoTMP) as Rank;
LOAD
*,

if(Platform= Previous(Platform), Peek(RowNoTMP) + 1, 1) as RowNoTMP

resident TBL
order by Platform , Value desc;

If You know any better solution, I'll be happy to know it 🙂