topic MTD for previous month in QlikView https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221357#M74175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please try the function.</P><P>=</P><BR /><BR /> <P><B>addmonths</B>(<B>DateField</B>,-1) . Ler me know is it useful or not?</P><P></P><P>Manesh Khot</P></BODY></HTML> Fri, 18 Feb 2011 09:39:41 GMT maneshkhottcpl 2011-02-18T09:39:41Z MTD for previous month https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221356#M74174 <HTML><HEAD></HEAD><BODY><P>HI all,</P><P>I m confused and not getting the logic..... for calculating "Month To date" for previous Month.</P><P>Please help by providing code for same . <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Fri, 18 Feb 2011 09:03:00 GMT https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221356#M74174 2011-02-18T09:03:00Z MTD for previous month https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221357#M74175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please try the function.</P><P>=</P><BR /><BR /> <P><B>addmonths</B>(<B>DateField</B>,-1) . Ler me know is it useful or not?</P><P></P><P>Manesh Khot</P></BODY></HTML> Fri, 18 Feb 2011 09:39:41 GMT https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221357#M74175 maneshkhottcpl 2011-02-18T09:39:41Z MTD for previous month https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221358#M74176 <HTML><HEAD></HEAD><BODY><P>I guess you want to calculate some amount for last MTD, if it is so, you can use something like this:</P><P style="background:#cedefd;">sum({Date={"&gt;=$(=MonthStart(today(),-1)) &lt;=$(=Addmonths(today(),-1))"}&gt;} Amount)</P><P style="background:#cedefd;">Regards, tresesco</P></BODY></HTML> Fri, 18 Feb 2011 09:53:17 GMT https://community.qlik.com/t5/QlikView/MTD-for-previous-month/m-p/221358#M74176 tresB 2011-02-18T09:53:17Z