You can do this using FirsValue() and LastValue() Function in QlikVeiw.
Your Script should be some thing like below one.
Load * inline [
TicketNumber, Station, Amount
1, E1, 0
1, K4, 3
1, A2, 3
2, E2, 0
2, K5, 6
2, A2, 6
FirstValue(Station) as EntryStation,
LastValue(Station) as Station,
LastValue(Station) as ExitStation
Resident Test Group By TicketNumber;
Have a look at the attached application.
Hope this helps you.
ticket.qvw 117.8 K