Qlik Sense - FirstSortedValue and Aggr

[tomdon14]

Hello - having an issue with FirstSortedValue and Aggr function. In the example below, I'm trying to identify the earliest month. I'm expecting that FirstSortedValue should be 201911 but formula is returning 201912. Any ideas? Thanks.

CASE_AER_NUMBER_VERSION	YearMonthNum	aggr(min(YearMonthNum), CASE_AER_NUMBER_VERSION)	FirstSortedValue(  YearMonthNum, aggr(min(YearMonthNum), CASE_AER_NUMBER_VERSION))
20151234567 (55)	201911	201911	-
20151234567 (55)	201912	-	201912

[tomdon14 · Accepted solution]

Thanks Sunny. I resolved it as follows with help from a different post of yours 😊: 

(https://community.qlik.com/t5/QlikView-Creating-Analytics/Using-set-analysis-aggregation/td-p/146172...)

YearMonth	CASE_AER_NUMBER_VERSION	sum(Aggr(if(YearMonthNum = Min({<YearMonth=>} TOTAL <CASE_AER_NUMBER_VERSION> YearMonthNum),1,0),CASE_AER_NUMBER_VERSION, YearMonthNum))
Nov-2019	20151234567 (55)	1