Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @Remco ,
I just tried to understand what restricting you for not using "max(PF_PORTFOLIOPERIOD, 2)". This will give second-highest value
Hi @Remco ,
I just tried to understand what restricting you for not using "max(PF_PORTFOLIOPERIOD, 2)". This will give second-highest value
I feel stupid... I did not know that, as simple as that. Thanks!