topic Re: Using current position in the year to make a calculation in QlikView https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530555#M198347 <HTML><HEAD></HEAD><BODY><P>Probably yes.</P><P></P><P>Maybe like</P><P></P><P>=round((today() - YearStart(today(),0,4) ) / 365 * 120)</P><P></P><P>where the third argument to yearstart() defines your financial year start (here: April).</P></BODY></HTML> Tue, 02 Jul 2013 11:01:07 GMT swuehl 2013-07-02T11:01:07Z Using current position in the year to make a calculation https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530552#M198344 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to show at the top of my dashboard, Planned Sessions (for the year) and Actual Sessions (for the year). The planned sessions is just a yearly figure for each consultant taken from a spreadsheet and the actual is a count of the session ids that have actually taken place. I need to show depending on the current date in the year what the consultant should have completed so far regarding the plan...</P><P></P><P>So, it is currently 3 months into the current year, the yearly figure is e.g. 120 so he should have completed 30. Is this possible? </P><P></P><P>Many Thanks,</P></BODY></HTML> Tue, 02 Jul 2013 10:36:26 GMT https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530552#M198344 2013-07-02T10:36:26Z Re: Using current position in the year to make a calculation https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530553#M198345 <HTML><HEAD></HEAD><BODY><P>Are you looking for something like</P><P></P><P>=month(today() ) / 12 * 120</P></BODY></HTML> Tue, 02 Jul 2013 10:45:28 GMT https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530553#M198345 swuehl 2013-07-02T10:45:28Z Re: Using current position in the year to make a calculation https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530554#M198346 <HTML><HEAD></HEAD><BODY><P>Is there anyway to do it using financial year?</P></BODY></HTML> Tue, 02 Jul 2013 10:53:30 GMT https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530554#M198346 2013-07-02T10:53:30Z Re: Using current position in the year to make a calculation https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530555#M198347 <HTML><HEAD></HEAD><BODY><P>Probably yes.</P><P></P><P>Maybe like</P><P></P><P>=round((today() - YearStart(today(),0,4) ) / 365 * 120)</P><P></P><P>where the third argument to yearstart() defines your financial year start (here: April).</P></BODY></HTML> Tue, 02 Jul 2013 11:01:07 GMT https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530555#M198347 swuehl 2013-07-02T11:01:07Z Re: Using current position in the year to make a calculation https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530556#M198348 <HTML><HEAD></HEAD><BODY><P>Thanks thats works perfectly.</P></BODY></HTML> Tue, 02 Jul 2013 11:07:52 GMT https://community.qlik.com/t5/QlikView/Using-current-position-in-the-year-to-make-a-calculation/m-p/530556#M198348 2013-07-02T11:07:52Z