Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

no 😞