topic Re: Balance Sheet & Last Year in QlikView https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186020#M383771 <HTML><HEAD></HEAD><BODY><P>You can use the AddYears function and also better to use set analysis instead of if like this:</P><P></P><P>=sum({&lt;[As At]={'$(=AddYears([As At],-1))'}&gt;}Balance)</P></BODY></HTML> Thu, 15 Sep 2016 14:52:13 GMT stigchel 2016-09-15T14:52:13Z Balance Sheet & Last Year https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186019#M383770 <HTML><HEAD></HEAD><BODY><P>Please find attached sample QVW.</P><P></P><P>I'm trying to create the sum for "Balance as at last year", depending on which As At date has been selected. I'm sure it's easy</P><P></P><P>Kev</P></BODY></HTML> Thu, 15 Sep 2016 14:44:39 GMT https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186019#M383770 kevbrown 2016-09-15T14:44:39Z Re: Balance Sheet & Last Year https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186020#M383771 <HTML><HEAD></HEAD><BODY><P>You can use the AddYears function and also better to use set analysis instead of if like this:</P><P></P><P>=sum({&lt;[As At]={'$(=AddYears([As At],-1))'}&gt;}Balance)</P></BODY></HTML> Thu, 15 Sep 2016 14:52:13 GMT https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186020#M383771 stigchel 2016-09-15T14:52:13Z Re: Balance Sheet & Last Year https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186021#M383772 <HTML><HEAD></HEAD><BODY><P>Superb, thank you</P></BODY></HTML> Thu, 15 Sep 2016 14:55:02 GMT https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186021#M383772 kevbrown 2016-09-15T14:55:02Z Re: Balance Sheet & Last Year https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186022#M383773 <HTML><HEAD></HEAD><BODY><P>You're welcome...</P><P></P><P>Maybe also add a e.g. Max to that expression for when nothing is selected:</P><P></P><P>=sum({&lt;[As At]={'$(=AddYears(<STRONG>Max</STRONG>([As At]),-1))'}&gt;}Balance)</P></BODY></HTML> Thu, 15 Sep 2016 15:02:49 GMT https://community.qlik.com/t5/QlikView/Balance-Sheet-Last-Year/m-p/1186022#M383773 stigchel 2016-09-15T15:02:49Z