topic Help With This Formula in QlikView https://community.qlik.com/t5/QlikView/Help-With-This-Formula/m-p/190934#M53228 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I have this formula:</P><P>sum( {$&lt;Año = {$(=max(Año) - $(=if(max(Mes) = 1, 1, 0)))}, Mes = {$(=if((Mes) = 1, 12, only(Mes)-1) )}, MonthYear = {"&lt;=$(=max MonthYear))"}&gt;} SALES)</P><P>I use it to calculate the sales of the previous month of the selected one. My questions is what i have to put in my formula to calculate the salews of the previous months when are more than one selected????, example</P><P>There are selected Mar 10, Feb10, Ene 10 and i need to calculate DIC 09, NOV 09 and OCT 09</P><P>Any ideas will be appreciate because i'm getting crazy with this issue</P><P>Regards</P><P>Carlos</P></BODY></HTML> Wed, 24 Mar 2010 04:01:43 GMT 2010-03-24T04:01:43Z Help With This Formula https://community.qlik.com/t5/QlikView/Help-With-This-Formula/m-p/190934#M53228 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I have this formula:</P><P>sum( {$&lt;Año = {$(=max(Año) - $(=if(max(Mes) = 1, 1, 0)))}, Mes = {$(=if((Mes) = 1, 12, only(Mes)-1) )}, MonthYear = {"&lt;=$(=max MonthYear))"}&gt;} SALES)</P><P>I use it to calculate the sales of the previous month of the selected one. My questions is what i have to put in my formula to calculate the salews of the previous months when are more than one selected????, example</P><P>There are selected Mar 10, Feb10, Ene 10 and i need to calculate DIC 09, NOV 09 and OCT 09</P><P>Any ideas will be appreciate because i'm getting crazy with this issue</P><P>Regards</P><P>Carlos</P></BODY></HTML> Wed, 24 Mar 2010 04:01:43 GMT https://community.qlik.com/t5/QlikView/Help-With-This-Formula/m-p/190934#M53228 2010-03-24T04:01:43Z