Qlik Sense - Identify Earliest Record

[tomdon14]

Hello –

Hoping someone might be able to assist. I have an issue trying to count the number of records by month. If the same record crosses over multiple months it should only be counted only in the earliest month. In the example below, 20180621200 (0) should be counted only in June. (Seems to be working correctly in the Summary Table.)

However, if I click on YearMonth to filter on the month in the Summary Table (201907) it now displays 20180621200 (0) incorrectly counted in July (see Summary Table Filtered). Any thoughts on how to ensure that the record is not displayed for July?

Thanks in advance.

[sunny_talwar]

May be try this

Sum(Aggr(
  If(YearMonthNum = Min({1} TOTAL <CASE_AER_NUMBER_VERSION> YearMonthNum), CASE_COUNTER, 0)
, YearMonthNum, CASE_AER_NUMBER_VERSION))