topic Re: how could I annualized 2021 in App Development

how could I annualized 2021

Ayden — Wed, 13 Oct 2021 22:49:49 GMT

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

Re: how could I annualized 2021

Digvijay_Singh — Thu, 14 Oct 2021 02:43:03 GMT

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.

Thanks,

Re: how could I annualized 2021

Ayden — Wed, 20 Oct 2021 18:41:07 GMT

thanks a lot