topic Re: previous year values using set analysis in QlikView https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464993#M173681 <HTML><HEAD></HEAD><BODY><P>try this addmonths(max(date),-2)</P></BODY></HTML> Tue, 30 Oct 2012 12:04:09 GMT sivarajs 2012-10-30T12:04:09Z previous year values using set analysis https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464990#M173678 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P></P><P>My requirement is that I have a&nbsp; month field called plan month . I need to find one month previous and two month previous values using set analysis.</P><P></P><P>I tried with addmonths but it is not proper for my requirement.</P><P></P><P>Can anyone tell me how to resolve with set analysis</P><P></P><P>Thanks</P></BODY></HTML> Tue, 30 Oct 2012 10:13:05 GMT https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464990#M173678 ssriramin19 2012-10-30T10:13:05Z Re: previous year values using set analysis https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464991#M173679 <HTML><HEAD></HEAD><BODY><P>SEE QVW I ATACH</P><P>HOPE IT HELP</P></BODY></HTML> Tue, 30 Oct 2012 10:29:48 GMT https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464991#M173679 fdelacal 2012-10-30T10:29:48Z Re: previous year values using set analysis https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464992#M173680 <HTML><HEAD></HEAD><BODY><P>Can you please tell me why the below code is not proper </P><P></P><P><SPAN style="color: #800080; font-size: 8pt;">&nbsp; </SPAN></P><P>date(num(only(Plan_For_Month-2))) .The month must be two months before from the current month .But it is not calculating proper.</P><P></P><P>Can anyone tell me how to resolve the above error</P></BODY></HTML> Tue, 30 Oct 2012 11:57:52 GMT https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464992#M173680 ssriramin19 2012-10-30T11:57:52Z Re: previous year values using set analysis https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464993#M173681 <HTML><HEAD></HEAD><BODY><P>try this addmonths(max(date),-2)</P></BODY></HTML> Tue, 30 Oct 2012 12:04:09 GMT https://community.qlik.com/t5/QlikView/previous-year-values-using-set-analysis/m-p/464993#M173681 sivarajs 2012-10-30T12:04:09Z