Script editor

[Enhpad]

Hello Qlik community,

I have been struggling with a certain script, I want my table to only show rows where column "Positiekey" is DISTINCT and Timestamp is MAX.

This is my current scripteditor:

CancelledOrders:
LOAD
"Timestamp",
PositieKey,

FirstSortedValue(PositieKey,Timestamp) as LatestOrder

Resident cancelledordersv1
Group By PositieKey
Order by PositieKey;

drop table cancelledordersv1;

[brunobertels]

hi 

may be this 

CancelledOrders:
LOAD
max("Timestamp")  as  Timestamp,
PositieKey,

//FirstSortedValue(PositieKey,Timestamp) as LatestOrder

Resident cancelledordersv1
Group By PositieKey
Order by PositieKey;

[BrunPierre · Accepted solution]

As below.

CancelledOrders:
LOAD
Timestamp(max("Timestamp")) as "Timestamp",
PositieKey,

FirstSortedValue(PositieKey,-Timestamp) as LatestOrder

Resident cancelledordersv1
Group By PositieKey
Order by PositieKey;

drop table cancelledordersv1;

[Enhpad]

Thank you! This did it for me in a test script, but apparently it was not working for me in my dashboard. So I still have to figure that one out.. 🤔