topic Re: Annualize Expression in QlikView https://community.qlik.com/t5/QlikView/Annualize-Expression/m-p/363146#M492145 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>there are two nice functions:</P><P></P><P>networkdays()</P><P></P><P>and </P><P></P><P>DayNumberOfYear()</P><P></P><P>Greetings from Munich</P><P></P><P>Martina</P></BODY></HTML> Mon, 23 Jul 2012 14:36:44 GMT brenner_martina 2012-07-23T14:36:44Z Annualize Expression https://community.qlik.com/t5/QlikView/Annualize-Expression/m-p/363145#M492144 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>I have attached an example of my data.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 23 Jul 2012 14:17:48 GMT https://community.qlik.com/t5/QlikView/Annualize-Expression/m-p/363145#M492144 2012-07-23T14:17:48Z Re: Annualize Expression https://community.qlik.com/t5/QlikView/Annualize-Expression/m-p/363146#M492145 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>there are two nice functions:</P><P></P><P>networkdays()</P><P></P><P>and </P><P></P><P>DayNumberOfYear()</P><P></P><P>Greetings from Munich</P><P></P><P>Martina</P></BODY></HTML> Mon, 23 Jul 2012 14:36:44 GMT https://community.qlik.com/t5/QlikView/Annualize-Expression/m-p/363146#M492145 brenner_martina 2012-07-23T14:36:44Z