topic Re: Sum Sales for previous 12 months in QlikView https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387898#M144732 <HTML><HEAD></HEAD><BODY><P>Thxs sir!</P></BODY></HTML> Wed, 02 Jan 2013 19:11:45 GMT alec1982 2013-01-02T19:11:45Z Sum Sales for previous 12 months https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387896#M144730 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Anybody can help me on why this is not working. I am trying to get the sales for the last 12 months.</P><P></P><P>Num(sum({$&lt;[Date]={'&gt;=$(=AddMonths(Today(),-12)'}&gt;}[Sales]),'#,##0')</P><P></P><P></P><P>Thxs,</P><P>Alec</P></BODY></HTML> Wed, 02 Jan 2013 18:59:16 GMT https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387896#M144730 alec1982 2013-01-02T18:59:16Z Re: Sum Sales for previous 12 months https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387897#M144731 <HTML><HEAD></HEAD><BODY><P>It's missing a '<STRONG>)</STRONG>' to close the AddMonths function:</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Num(sum({$&lt;[Date]={'&gt;=$(=AddMonths(Today(),-12))'}&gt;}[Sales]),'#,##0')</SPAN></P></BODY></HTML> Wed, 02 Jan 2013 19:05:21 GMT https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387897#M144731 Gysbert_Wassenaar 2013-01-02T19:05:21Z Re: Sum Sales for previous 12 months https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387898#M144732 <HTML><HEAD></HEAD><BODY><P>Thxs sir!</P></BODY></HTML> Wed, 02 Jan 2013 19:11:45 GMT https://community.qlik.com/t5/QlikView/Sum-Sales-for-previous-12-months/m-p/387898#M144732 alec1982 2013-01-02T19:11:45Z