Set Analysis: how to select next year field value

[g23]

Dear all,

I can't find a way to write a measure that selects each time (current year) and (current year+1) field value.

I need to be able to select this fields' "premio_imp_rinnovo" value in year 2016 and 2017 or 2017 and 2018 and so on.

This syntax doesn't seem to work but I can't understand why:

sum({1<Anno_dinizio_copertura = {$(=([Anno_dinizio_copertura])+1)}>}premio_imp_rinnovo)

 *Interval(YearEnd(dfine_copertura) - dfine_copertura,'d')/365
+
sum({1<Anno_dinizio_copertura = {$(=([Anno_dinizio_copertura])-1)}>}premio_imp_rinnovo *
Interval(AddYears(dinizio_copertura,-1) - YearStart(AddYears(dinizio_copertura,-1)),'d')/365

Is there a way to do so in Qliksense? I tried different functions but nothing seems to work

Thank you all

[vlad_komarov]

I have the same issue, but with request to do it by Day (Sun this week vs. Sun last week).

Did you manage to find a solution?

VK

[g23]

no 😞