First sorted Value for min and max date for each ID
I am very new to qlikview and trying to get my head around the first sorted value functionality.
My problem is i have 3 columns
PRIMARY ID , EVENTS , TIMESTAMP
now i want to find for each primary ID the event at max and min time. Primary id is getting repeated as an id has to go through the lifecycle and i have to find the stage at max time and min time in same table.