Max(Year) for the Selected Months

[profilejamesbond]

Hi Qlik Community,

I have Qlik Sense App where I have Year and Month fields. Now, if I select Month decemeber then it must return me the max year automatically. If I select two or multiple months like Oct and Nov then it must return me the max year that is associated with this months selections. October, November, December belongs to 2024 automatically because the Calendar otherwise default selections must work. Like user select year 2023 then only 2023 months appear.

I want to make an expression that must reflect like the above scenario in the table.

How to do it ?

Thanks,

[Clement15]

Hello, does this formula meet your expectations?

min(aggr(max([Year]),Month))

[profilejamesbond]

Hi Clement15,

Aggregation is not an option.

[Anil_Babu_Samineni]

You can see TOTAL qualifier with this, but before that do you have sample data set and output you want?