In this Qlik Sense Tutorial Video I have talked about how you can pick the first value and last value of a column for the purpose of your analysis.
Like what I am doing? Buy me a Coffee to re-energize - https://tinyurl.com/txe98jf
Data set - https://tinyurl.com/yd65vnf3 (Look for qlik sense folder here)