Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

how could I annualized 2021

hello Qlik Family, have Year field with years ranging from 2015 to 2021. I would like to annualize data for 2021 to get a full picture with my charts when compared to rest of the years i.e 2020 down to 2015. Since we still have 2 months to go for 2021 I can’t really get full picture of the entire year.


Thanks in advance

1 Reply

Something like this may be- 

Avg(Aggr(Count([ID]),[Month Year])) * (12/Num(Month(Monthend(today(),-1))))

The 2nd calculation above will multiply 1 if its full one year else it would multiply 12/(total running months) to identify the annualized value. Not sure how you would form the first part based on your metric requirement.