Question about finding the value previous to MAX

[Remco]

Good morning all,

I am still learning Qlik and I am running in all kinds of issues. Many of them I solve via this community, others not. Like the next issue:

I am able to find the sum of the value belonging to the max PF_PORTFOLIOPERIOD in the next expression

=Sum({<TYPE = {"FLEETSIZE OL"}, PORTFOLIOPERIOD = {"$(=MAX(PF_PORTFOLIOPERIOD))"}>} ACTUAL)

How can I find the the same belonging to the PF_PORTFOLIOPERIOD just before the max? These periods are always 12 values in the actual example. I cannot just substract a fixed number as these periods are build up as year & month like 201909, 201910, 201911, 201912, 202001 etc. 

Thanks!

[premvihari · Accepted solution]

Hi @Remco ,

I just tried to understand what restricting you for not using  "max(PF_PORTFOLIOPERIOD, 2)". This will give second-highest value 

[Remco]

I feel stupid... I did not know that, as simple as that. Thanks!