topic adding months in a variable in QlikView https://community.qlik.com/t5/QlikView/adding-months-in-a-variable/m-p/51497#M8514 <HTML><HEAD></HEAD><BODY><P>Hi I have a variable I am using to show current monthminus1 data and it works fine</P><P></P><P>=floor(AddMonths(<STRONG>vnp_CurrentMonth</STRONG>, -1))</P><P></P><P>the <STRONG>vnp_currentMonth i</STRONG>s a variable that takes the selected month and is used in the above:</P><P></P><P>=floor(MonthStart(vSelectedYearMonth))</P><P></P><P>so the above will show data for the selected month minus one month.&nbsp; I want a variable that will add the current month-1 the current month-2 and the current month-3 so for instance if January is selected it will add the data for Oct, Nov and Dec and display them.</P><P></P><P>The full expression that uses this for your information is:</P><P></P><P>NUM(SUM({&lt;[PA2]={21}, DateNo={'$(vnp_CurrentMonthMinus1)'}, ReferredMM=, YearMonth=&gt;}ActualValue), '#,##0'),</P><P></P><P>Any help appreciated</P></BODY></HTML> Mon, 05 Mar 2018 15:27:21 GMT rcorcoran 2018-03-05T15:27:21Z adding months in a variable https://community.qlik.com/t5/QlikView/adding-months-in-a-variable/m-p/51497#M8514 <HTML><HEAD></HEAD><BODY><P>Hi I have a variable I am using to show current monthminus1 data and it works fine</P><P></P><P>=floor(AddMonths(<STRONG>vnp_CurrentMonth</STRONG>, -1))</P><P></P><P>the <STRONG>vnp_currentMonth i</STRONG>s a variable that takes the selected month and is used in the above:</P><P></P><P>=floor(MonthStart(vSelectedYearMonth))</P><P></P><P>so the above will show data for the selected month minus one month.&nbsp; I want a variable that will add the current month-1 the current month-2 and the current month-3 so for instance if January is selected it will add the data for Oct, Nov and Dec and display them.</P><P></P><P>The full expression that uses this for your information is:</P><P></P><P>NUM(SUM({&lt;[PA2]={21}, DateNo={'$(vnp_CurrentMonthMinus1)'}, ReferredMM=, YearMonth=&gt;}ActualValue), '#,##0'),</P><P></P><P>Any help appreciated</P></BODY></HTML> Mon, 05 Mar 2018 15:27:21 GMT https://community.qlik.com/t5/QlikView/adding-months-in-a-variable/m-p/51497#M8514 rcorcoran 2018-03-05T15:27:21Z Re: adding months in a variable https://community.qlik.com/t5/QlikView/adding-months-in-a-variable/m-p/51498#M8515 <HTML><HEAD></HEAD><BODY><P>Actually sorry I just figured it out straight after posting this:</P><P></P><P>NUM(SUM({&lt;[PA2]={21}, DateNo={'$(vnp_CurrentMonthMinus1)','$(vnp_CurrentMonthMinus2)','$(vnp_CurrentMonthMinus3)'}, ReferredMM=, YearMonth=&gt;}ActualValue), '#,##0'), </P></BODY></HTML> Mon, 05 Mar 2018 15:33:22 GMT https://community.qlik.com/t5/QlikView/adding-months-in-a-variable/m-p/51498#M8515 rcorcoran 2018-03-05T15:33:22Z