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.
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.