Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
g23
Contributor III
Contributor III

Set Analysis: how to select next year field value

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

2 Replies
vlad_komarov
Partner - Specialist III
Partner - Specialist III

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
Contributor III
Contributor III
Author

no 😞