topic Script editor in App Development

Script editor

Enhpad — Fri, 18 Nov 2022 13:44:45 GMT

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;

Re: Script editor

brunobertels — Fri, 18 Nov 2022 14:06:15 GMT

may be this

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

//FirstSortedValue(PositieKey,Timestamp) as LatestOrder

Resident cancelledordersv1
Group By PositieKey
Order by PositieKey;

Re: Script editor

BrunPierre — Fri, 18 Nov 2022 14:38:44 GMT

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;

Re: Script editor

Enhpad — Sat, 19 Nov 2022 21:09:59 GMT

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.. 🤔