topic MTD in straight table in QlikView https://community.qlik.com/t5/QlikView/MTD-in-straight-table/m-p/835838#M294036 <HTML><HEAD></HEAD><BODY><P>Hi, QVers,</P><P></P><P>After did some search and test, I am stucked to use MTD in a pivot/straight table with Week as a dimension. </P><P>What I want is a straight, and later a pivot table as below:</P><P></P><P>Week,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WeekEnd,&nbsp; sum(A), sum(B), sum(C),&nbsp; MTD sum(C)</P><P>2015-18, 2015-05-03,&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp; sum(Date={"&gt;='2015-05-01'&lt;='2015-05-03'"}C )</P><P><SPAN style="font-size: 13.3333330154419px;">2015-19, 2015-05-10,&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp; <SPAN style="font-size: 13.3333330154419px;">sum(Date={"&gt;='2015-05-01'&lt;='2015-05-10'" }C)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;">2015-20, 2015-05-17,&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp; </SPAN><SPAN style="font-size: 13.3333330154419px;">sum(Date={"&gt;='2015-05-01'&lt;='2015-05-17'"}C )</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">I tried, seems because "Week" is an dimension, sum({1}C) =sum(C), so the set analysis Date range dose not work.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">May I know how to calculate the MTC in this case?</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Thanks very much<BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P></BODY></HTML> Fri, 22 May 2015 12:54:52 GMT Anonymous 2015-05-22T12:54:52Z MTD in straight table https://community.qlik.com/t5/QlikView/MTD-in-straight-table/m-p/835838#M294036 <HTML><HEAD></HEAD><BODY><P>Hi, QVers,</P><P></P><P>After did some search and test, I am stucked to use MTD in a pivot/straight table with Week as a dimension. </P><P>What I want is a straight, and later a pivot table as below:</P><P></P><P>Week,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WeekEnd,&nbsp; sum(A), sum(B), sum(C),&nbsp; MTD sum(C)</P><P>2015-18, 2015-05-03,&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp; sum(Date={"&gt;='2015-05-01'&lt;='2015-05-03'"}C )</P><P><SPAN style="font-size: 13.3333330154419px;">2015-19, 2015-05-10,&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp; <SPAN style="font-size: 13.3333330154419px;">sum(Date={"&gt;='2015-05-01'&lt;='2015-05-10'" }C)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;">2015-20, 2015-05-17,&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp; </SPAN><SPAN style="font-size: 13.3333330154419px;">sum(Date={"&gt;='2015-05-01'&lt;='2015-05-17'"}C )</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">I tried, seems because "Week" is an dimension, sum({1}C) =sum(C), so the set analysis Date range dose not work.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">May I know how to calculate the MTC in this case?</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Thanks very much<BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P></BODY></HTML> Fri, 22 May 2015 12:54:52 GMT https://community.qlik.com/t5/QlikView/MTD-in-straight-table/m-p/835838#M294036 Anonymous 2015-05-22T12:54:52Z Re: MTD in straight table https://community.qlik.com/t5/QlikView/MTD-in-straight-table/m-p/835839#M294037 <HTML><HEAD></HEAD><BODY><P>Perhaps this document helps: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; text-decoration: underline;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 22 May 2015 13:11:32 GMT https://community.qlik.com/t5/QlikView/MTD-in-straight-table/m-p/835839#M294037 Gysbert_Wassenaar 2015-05-22T13:11:32Z