Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

Aggregation of the following year

Hi everyone,
I have the following problem:

I have a combochart that keeps the values referring to the current period, the forecast one and the difference of the current one with the following one, for example:

Value Actual 2018, Budget 2018 and Actual 2018-Actual2017.

The chart is a time dimension that can be: month, quarter, half year or year, based on the selection of a variable.

 

Furthermore, to enhance the numerical fields I am using a set analysis where I entered the dates that have been selected, for example:

I select from 01/01/2018 to 31/12/2018 and then in the set analysis I will have that date must be contained between these values.

 

Would there be a way to tell him to aggregate considering the previous year?

 

 

Thanks,

Livio

 

Labels (3)
0 Replies