topic Re: set analysis error in QlikView https://community.qlik.com/t5/QlikView/set-analysis-error/m-p/898727#M312642 <HTML><HEAD></HEAD><BODY><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Sum({$&lt;TimeLine.Year={$(=<STRONG>max</STRONG>(TimeLine.Year)-1)}&gt;}(Fact.CustomerSales*[CurrencyConversion.USD - Budgeted Rate CFY]))</SPAN></P></BODY></HTML> Thu, 23 Apr 2015 22:58:33 GMT maxgro 2015-04-23T22:58:33Z set analysis error https://community.qlik.com/t5/QlikView/set-analysis-error/m-p/898726#M312641 <HTML><HEAD></HEAD><BODY><P>I'm trying to use this expression to find previous year sale .</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">=Sum({$&lt;TimeLine.Year={$(=(TimeLine.Year)-1)}&gt;}(Fact.CustomerSales*[CurrencyConversion.USD - Budgeted Rate CFY]))</SPAN></P><P></P><P>when i execute this expression it displays zero . where as i do have sales for that year . i'm defn missing something in this expression ... but im not able to figure out .</P><P></P><P>pls help</P></BODY></HTML> Thu, 23 Apr 2015 22:50:44 GMT https://community.qlik.com/t5/QlikView/set-analysis-error/m-p/898726#M312641 arusanah 2015-04-23T22:50:44Z Re: set analysis error https://community.qlik.com/t5/QlikView/set-analysis-error/m-p/898727#M312642 <HTML><HEAD></HEAD><BODY><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Sum({$&lt;TimeLine.Year={$(=<STRONG>max</STRONG>(TimeLine.Year)-1)}&gt;}(Fact.CustomerSales*[CurrencyConversion.USD - Budgeted Rate CFY]))</SPAN></P></BODY></HTML> Thu, 23 Apr 2015 22:58:33 GMT https://community.qlik.com/t5/QlikView/set-analysis-error/m-p/898727#M312642 maxgro 2015-04-23T22:58:33Z