Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Cut out Dataset with a calculated dimension

Hello,

I have the following table: 

 

QueueNo.ActionNo.ActionNameStartFinished
11115000Start08:0008:05
11115001Moving08:0508:10
11115002Parking08:1008:12
11115003Moving08:1208:29
11115004Success08:2908:30
22225100Start09:0009:00
22225101Moving09:0109:10
22225102Failed09:1009: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. 

1 Reply
Taoufiq_Zarra

@Applicable88  multiple

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

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉