topic Re: Syntax MonthYear in QlikView https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15560#M511346 <HTML><HEAD></HEAD><BODY><P>Did you checked out the suggestion from this thread of yours?</P><P><A href="https://community.qlik.com/thread/291096">MonthYear</A></P></BODY></HTML> Tue, 13 Feb 2018 12:17:59 GMT sunny_talwar 2018-02-13T12:17:59Z Syntax MonthYear https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15558#M511344 <HTML><HEAD></HEAD><BODY><P>Hi Guys!</P><P>i have build the formula below that is working perfectly.</P><P>BTW i have to create another one where the SurgeryMonthYear should be the MonthYear minus 12 months. Anyone knows which is the right syntax?</P><P>Thanks!</P><P></P><P>=Sum({&lt;<STRONG>SurgeryMonthYear={$(=concat(chr(39) &amp; MonthYear &amp; chr(39),',') )},</STRONG>MonthYear=,Day=,Year=,Month=,Quarter=&gt;}[Surgical Procedures WI])</P></BODY></HTML> Tue, 13 Feb 2018 11:27:32 GMT https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15558#M511344 qlikviewaf 2018-02-13T11:27:32Z Re: Syntax MonthYear https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15559#M511345 <HTML><HEAD></HEAD><BODY><P>You can use AddYears() / AddMonths() function to get the date one year ago.</P><P></P><P>AddYears(MonthYear,-1)</P><P></P><P>use a Date() or MonthName() format to get the same format required by your SurgeryMonthYear, e.g.</P><P></P><P>MonthName(AddYears(MonthYear,-1))</P></BODY></HTML> Tue, 13 Feb 2018 11:35:05 GMT https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15559#M511345 swuehl 2018-02-13T11:35:05Z Re: Syntax MonthYear https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15560#M511346 <HTML><HEAD></HEAD><BODY><P>Did you checked out the suggestion from this thread of yours?</P><P><A href="https://community.qlik.com/thread/291096">MonthYear</A></P></BODY></HTML> Tue, 13 Feb 2018 12:17:59 GMT https://community.qlik.com/t5/QlikView/Syntax-MonthYear/m-p/15560#M511346 sunny_talwar 2018-02-13T12:17:59Z