topic Re: Autocalendar | Previous YTD in App Development https://community.qlik.com/t5/App-Development/Autocalendar-Previous-YTD/m-p/3137#M231 <HTML><HEAD></HEAD><BODY><P>What does your derived calendar script look like? Is it assigning 1 for true or -1?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190522_Capture.PNG" style="height: auto;" /></P><P></P><P>If it is -1, then try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: tahoma, arial, helvetica, sans-serif; font-size: 13px;"><STRONG>Sum({&lt;[Date.autoCalendar.InYTD]={'-1'},[Date.autoCalendar.YearsAgo]={<SPAN style="color: #3d3d3d; font-family: tahoma, arial, helvetica, sans-serif; font-size: 13px;">'-1'</SPAN>} [Sales])</STRONG></SPAN></P></BODY></HTML> Thu, 18 Jan 2018 14:58:04 GMT sunny_talwar 2018-01-18T14:58:04Z Autocalendar | Previous YTD https://community.qlik.com/t5/App-Development/Autocalendar-Previous-YTD/m-p/3136#M230 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Hello all,</SPAN></DIV><DIV><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">I'm tying to achieve a Previous YTD measure using autocalendar. Is this possible?</SPAN></DIV><DIV><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"><BR /></SPAN></DIV><DIV><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">I'm using the below, but the incorrect result is returned (0).</SPAN></DIV><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">SUM({&lt;[Date.autoCalendar.InYTD]={1},[Date.autoCalendar.YearsAgo]={1} [Sales])</SPAN> </P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><DIV><DIV> </DIV></DIV><DIV><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Thanks</SPAN></DIV></BODY></HTML> Thu, 18 Jan 2018 14:46:21 GMT https://community.qlik.com/t5/App-Development/Autocalendar-Previous-YTD/m-p/3136#M230 fosterma 2018-01-18T14:46:21Z Re: Autocalendar | Previous YTD https://community.qlik.com/t5/App-Development/Autocalendar-Previous-YTD/m-p/3137#M231 <HTML><HEAD></HEAD><BODY><P>What does your derived calendar script look like? Is it assigning 1 for true or -1?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190522_Capture.PNG" style="height: auto;" /></P><P></P><P>If it is -1, then try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: tahoma, arial, helvetica, sans-serif; font-size: 13px;"><STRONG>Sum({&lt;[Date.autoCalendar.InYTD]={'-1'},[Date.autoCalendar.YearsAgo]={<SPAN style="color: #3d3d3d; font-family: tahoma, arial, helvetica, sans-serif; font-size: 13px;">'-1'</SPAN>} [Sales])</STRONG></SPAN></P></BODY></HTML> Thu, 18 Jan 2018 14:58:04 GMT https://community.qlik.com/t5/App-Development/Autocalendar-Previous-YTD/m-p/3137#M231 sunny_talwar 2018-01-18T14:58:04Z