topic YTD View in QlikView https://community.qlik.com/t5/QlikView/YTD-View/m-p/321073#M1180285 <HTML><HEAD></HEAD><BODY><P>Hi, all,</P><P></P><P>I'm trying to generate a YTD view on a certain metric, but the coding that I am using isn't working for some reason. I can't spot any syntax errors...</P><P></P><P>The code structure that I have been playing with is as follows:</P><P></P><P>(sum({&lt;Month_Start={"&gt;=$(=Date(addmonths(Max(Month_Start), -(Num(Month)-1)), 'MMM-YYYY' ))&lt;=$(=Date(addmonths(Max(Month_Start),0), 'MMM-YYYY')) "}&gt;} [FIELD NAME])</P><P></P><P>Help???</P></BODY></HTML> Thu, 22 Dec 2011 17:47:27 GMT 2011-12-22T17:47:27Z YTD View https://community.qlik.com/t5/QlikView/YTD-View/m-p/321073#M1180285 <HTML><HEAD></HEAD><BODY><P>Hi, all,</P><P></P><P>I'm trying to generate a YTD view on a certain metric, but the coding that I am using isn't working for some reason. I can't spot any syntax errors...</P><P></P><P>The code structure that I have been playing with is as follows:</P><P></P><P>(sum({&lt;Month_Start={"&gt;=$(=Date(addmonths(Max(Month_Start), -(Num(Month)-1)), 'MMM-YYYY' ))&lt;=$(=Date(addmonths(Max(Month_Start),0), 'MMM-YYYY')) "}&gt;} [FIELD NAME])</P><P></P><P>Help???</P></BODY></HTML> Thu, 22 Dec 2011 17:47:27 GMT https://community.qlik.com/t5/QlikView/YTD-View/m-p/321073#M1180285 2011-12-22T17:47:27Z Re: YTD View https://community.qlik.com/t5/QlikView/YTD-View/m-p/321074#M1180286 <HTML><HEAD></HEAD><BODY><P>I think the formula would be a little easier it is was something like below:</P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum({&lt;Month_Start={"&lt;=$(=Max(Month_Start)) "},Year={$(=max(Year))}&gt;} [FIELD NAME])</SPAN></P><P></P><P>Karl</P></BODY></HTML> Thu, 22 Dec 2011 18:30:18 GMT https://community.qlik.com/t5/QlikView/YTD-View/m-p/321074#M1180286 pover 2011-12-22T18:30:18Z