https://community.qlik.com/t5/QlikView/Sum-last-n-months/m-p/1570371#M456848 <P>Can you please check, If there is any problem with date format?</P><P><STRONG>=Sum({&lt;DocumentoFechaEmision={"&gt;=$(=<FONT color="#FF0000">Date(</FONT>MonthStart(AddMonths(Max(DocumentoFechaEmision),-12))<FONT color="#FF0000">,'Your Field Format')</FONT>)&lt;=$(=<FONT color="#FF0000">Date(</FONT>MonthEnd(AddMonths(Max(DocumentoFechaEmision),-1))<FONT color="#FF0000">,'Your Field Format')</FONT>)"}&gt;}SOLES)</STRONG></P> Wed, 17 Apr 2019 09:11:36 GMT saminea_ANZ 2019-04-17T09:11:36Z https://community.qlik.com/t5/QlikView/Sum-last-n-months/m-p/1570195#M456847 <P>Morning... I want to sum last 12 months... I put this expression but don't sum...</P><P>&nbsp;</P><P>=Sum({&lt;DocumentoFechaEmision={"&gt;=$(=MonthStart(AddMonths(Max(DocumentoFechaEmision),-12)))&lt;=$(=MonthEnd(AddMonths(Max(DocumentoFechaEmision),-1)))"}&gt;}SOLES)</P><P>&nbsp;</P><P>DocumentoFechaEmision = The date of the bill, with the month obviously</P><P>SOLES = The quantity to sum</P><P>&nbsp;</P><P>Please help...</P> Sat, 16 Nov 2024 21:02:11 GMT https://community.qlik.com/t5/QlikView/Sum-last-n-months/m-p/1570195#M456847 RubénHPaz 2024-11-16T21:02:11Z https://community.qlik.com/t5/QlikView/Sum-last-n-months/m-p/1570371#M456848 <P>Can you please check, If there is any problem with date format?</P><P><STRONG>=Sum({&lt;DocumentoFechaEmision={"&gt;=$(=<FONT color="#FF0000">Date(</FONT>MonthStart(AddMonths(Max(DocumentoFechaEmision),-12))<FONT color="#FF0000">,'Your Field Format')</FONT>)&lt;=$(=<FONT color="#FF0000">Date(</FONT>MonthEnd(AddMonths(Max(DocumentoFechaEmision),-1))<FONT color="#FF0000">,'Your Field Format')</FONT>)"}&gt;}SOLES)</STRONG></P> Wed, 17 Apr 2019 09:11:36 GMT https://community.qlik.com/t5/QlikView/Sum-last-n-months/m-p/1570371#M456848 saminea_ANZ 2019-04-17T09:11:36Z