Creating a new field based on other fields in dataset

[Jnkansayeboah]

I would like to learn how to create the field 'Furthest Hiring Stage For Candidates Per Job Requisitions' in my dataset attached. This field should show the furthest hiring stage for each candidate for each job they applied to. I am using QlikSense. How would I do this on QlikSense please?

[Frank_Hartmann]

Maybe like this:

test1:
LOAD [Job Requisition Identifier], 
     [Candidate Identifier], 
     [Date Of Stages], 
     [Hiring Stages]     
FROM [Training Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

left join

test2:
Load  [Job Requisition Identifier],      
     max([Date Of Stages]) as Date,      
     FirstSortedValue([Hiring Stages],-[Date Of Stages]) as Data 
Resident test1 Group by [Job Requisition Identifier];