Qlik Sense - Identify Earliest Record

tomdon14 — Tue, 21 Dec 2021 21:48:24 GMT

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.

Re: Qlik Sense - Identify Earliest Record

sunny_talwar — Mon, 30 Mar 2020 15:30:08 GMT

May be try this

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

topic Re: Qlik Sense - Identify Earliest Record in App Development

Qlik Sense - Identify Earliest Record

Re: Qlik Sense - Identify Earliest Record