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:
FirstSortedValue(PositieKey,Timestamp) as LatestOrder
Group By PositieKey
Order by PositieKey;
drop table cancelledordersv1;