Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table of trips with different stops on each trip (numbered in sequence) with the time of departure and arrival at each stop.
Trip, Sequence, Departure, Arrival
For each trip, I only need the departure time of the first sequence and the arrival time of the last sequence:
Trip, Departure, Arrival
Many thanks to the community for their help
LOAD * INLINE [
LOAD Trip, FirstSortedValue(Departure, Sequence) as Departure, FirstSortedValue(Arrival,-Sequence) as Arrival
GROUP BY Trip;
DROP Table INPUT;