Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to rank results in the same way as a rank function does in sql server:
I've already tried:
with order by Platform, Value
Is there a way to do this in QlikView?
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 TBLorder by Platform , Value desc;
If You know any better solution, I'll be happy to know it 🙂