topic Re: YTD,MTD in QlikView https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487422#M182048 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this hope this helps you</P><P>for ytd--</P><P><STRONG>sum({&lt;Date={"&gt;=$(=yearstart(max(Date)))&lt;=$(=max(Date))"},year=,month=&gt;}sales)</STRONG></P><P></P><P>for mtd--</P><P><STRONG>sum({&lt;Date={"&gt;=$(=Monthstart(max(Date)))&lt;=$(=MonthEnd(max(Date))),year=month=&gt;}sales)</STRONG></P><P></P><P><STRONG>Regards</STRONG></P><P><STRONG>vishwaranjan<BR /></STRONG></P></BODY></HTML> Tue, 13 Aug 2013 05:10:38 GMT 2013-08-13T05:10:38Z YTD,MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487420#M182046 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>i have data from 2011 to till date, from that how to Calculate YTD,MTD values...provide me Set analysis Expressions for that please...</P><P></P><P></P><P></P><P>Thanks in advance!!!</P><P>Smiley</P></BODY></HTML> Tue, 13 Aug 2013 04:55:20 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487420#M182046 rathnam_qv 2013-08-13T04:55:20Z Re: YTD,MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487421#M182047 <HTML><HEAD></HEAD><BODY><P>Have a look <A _jive_internal="true" href="https://community.qlik.com/message/363419#363419">here</A></P></BODY></HTML> Tue, 13 Aug 2013 04:59:59 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487421#M182047 tresB 2013-08-13T04:59:59Z Re: YTD,MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487422#M182048 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this hope this helps you</P><P>for ytd--</P><P><STRONG>sum({&lt;Date={"&gt;=$(=yearstart(max(Date)))&lt;=$(=max(Date))"},year=,month=&gt;}sales)</STRONG></P><P></P><P>for mtd--</P><P><STRONG>sum({&lt;Date={"&gt;=$(=Monthstart(max(Date)))&lt;=$(=MonthEnd(max(Date))),year=month=&gt;}sales)</STRONG></P><P></P><P><STRONG>Regards</STRONG></P><P><STRONG>vishwaranjan<BR /></STRONG></P></BODY></HTML> Tue, 13 Aug 2013 05:10:38 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/487422#M182048 2013-08-13T05:10:38Z