Cut out Dataset with a calculated dimension

[Applicable88]

Hello,

I have the following table: 

QueueNo.	ActionNo.	ActionName	Start	Finished
1111	5000	Start	08:00	08:05
1111	5001	Moving	08:05	08:10
1111	5002	Parking	08:10	08:12
1111	5003	Moving	08:12	08:29
1111	5004	Success	08:29	08:30
2222	5100	Start	09:00	09:00
2222	5101	Moving	09:01	09:10
2222	5102	Failed	09:10	09:10

I want a calculated dimension where I only see the first and last actionNo of a Queuno. I tried different methods to cut out the subactions. but I either get complete null or nothing happens. 

Hope someone has an idea. 

Best. 

[Taoufiq_Zarra · Accepted solution]

@Applicable88  multiple

https://community.qlik.com/t5/New-to-Qlik-Sense/Cut-out-Dataset-with-a-calculated-dimension/td-p/175...