topic Re: YTD and MTD in QlikView https://community.qlik.com/t5/QlikView/YTD-and-MTD/m-p/652997#M1075321 <HTML><HEAD></HEAD><BODY><P>Hi Arul,</P><P></P><P>do a search on the community and you will find many example of people asking about MTD and YTD, I suggest having a look first.</P><P>Two below from a quick search</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6163">YTQ, QTD, MTD and WTD</A></P><P></P><P><A href="https://community.qlik.com/message/509821">YTD MTD</A></P><P></P><P>Joe</P></BODY></HTML> Fri, 25 Jul 2014 11:06:13 GMT 2014-07-25T11:06:13Z YTD and MTD https://community.qlik.com/t5/QlikView/YTD-and-MTD/m-p/652996#M1075320 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i need to display in straight table like this i used OrderNum as dimension </P><P></P><P>OrderNum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YTD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD&nbsp;&nbsp;&nbsp; WTD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp; ....</P><P></P><P>i used set analysis </P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(YearStart(Max(DateNum))))&lt;=$(=Max(DateNum))"}&gt;} Sales)</SPAN></P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">But i am getting zero result any help?<BR /></SPAN></P></BODY></HTML> Fri, 25 Jul 2014 10:50:02 GMT https://community.qlik.com/t5/QlikView/YTD-and-MTD/m-p/652996#M1075320 arulsettu 2014-07-25T10:50:02Z Re: YTD and MTD https://community.qlik.com/t5/QlikView/YTD-and-MTD/m-p/652997#M1075321 <HTML><HEAD></HEAD><BODY><P>Hi Arul,</P><P></P><P>do a search on the community and you will find many example of people asking about MTD and YTD, I suggest having a look first.</P><P>Two below from a quick search</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6163">YTQ, QTD, MTD and WTD</A></P><P></P><P><A href="https://community.qlik.com/message/509821">YTD MTD</A></P><P></P><P>Joe</P></BODY></HTML> Fri, 25 Jul 2014 11:06:13 GMT https://community.qlik.com/t5/QlikView/YTD-and-MTD/m-p/652997#M1075321 2014-07-25T11:06:13Z