Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Annualize Expression

I need to annualize an expression that sums up 2012 Revenue YTD. I would like it to take the 2012 Revenue YTD, divide it by the number of work days that have passed in the year, and multiply that by the total number of work days in the year. Is there a way to do this in the expression so that I won't have to change the divisor manually everyday?

I have attached an example of my data.

Thanks!

1 Reply
brenner_martina
Valued Contributor II

Re: Annualize Expression

Hi,

there are two nice functions:

networkdays()

and

DayNumberOfYear()

Greetings from Munich

Martina

Community Browser