topic Re: AddYears - how to? in QlikView https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191192#M882356 <HTML><HEAD></HEAD><BODY><P>2008</P></BODY></HTML> Wed, 28 Sep 2016 17:29:45 GMT 2016-09-28T17:29:45Z AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191189#M882353 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN"> </SPAN></P><P>how do I modify the code below to be able to<SPAN style="color: #575757;"> <SPAN style="color: #3366ff;">1 year less</SPAN></SPAN> than the SELECTED year?　 I tried adding the ADDYEARS and a -1 to the code, but couldn’t get it to work correctly.　</P><P></P><P><SPAN lang="EN"></SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff; font-family: Arial;">Num</SPAN><SPAN style="font-family: Arial;">(</SPAN><SPAN style="color: #0000ff; font-family: Arial;">Sum</SPAN><SPAN style="font-family: Arial;">({&lt;</SPAN><SPAN style="color: #800000; font-family: Arial;">[Account Description]</SPAN><SPAN style="font-family: Arial;"> = {'Total COGS'}, </SPAN><SPAN style="color: #800000; font-family: Arial;">MonthYear</SPAN><SPAN style="font-family: Arial;"> = {</SPAN><SPAN style="color: #800000; font-family: Arial;">"$(='&gt;' &amp; Date(AddMonths(QuarterStart(AddMonths(Max(MonthYear), 1))-1, -12)) &amp; '&lt;=' &amp; Date(QuarterStart(AddMonths(Max(MonthYear), 1))-1))"</SPAN><SPAN style="font-family: Arial;">}, </SPAN><SPAN style="color: #800000; font-family: Arial;">Year</SPAN><SPAN style="font-family: Arial;">, </SPAN><SPAN style="color: #800000; font-family: Arial;">Month</SPAN><SPAN style="font-family: Arial;">, </SPAN><SPAN style="color: #800000; font-family: Arial;">Quarter</SPAN><SPAN style="font-family: Arial;">&gt;} </SPAN><SPAN style="color: #800000; font-family: Arial;">Actual</SPAN></SPAN><SPAN style="font-size: 10pt; font-family: Arial;">),'#,##0') </SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: Arial;"> Thank you for any assistance you can offer!!!!</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial;">Kelly</SPAN></P><P></P><P></P><P><SPAN style="font-size: 10pt; font-family: Arial;"><A href="https://community.qlik.com/qlik-users/171708" target="_blank">stalwar1</A>‌</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191189#M882353 2020-11-25T16:16:04Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191190#M882354 <HTML><HEAD></HEAD><BODY><P>what is ur year format ?</P><P></P><P></P><P>-nagarjun</P></BODY></HTML> Wed, 28 Sep 2016 17:26:33 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191190#M882354 nagarjuna_kotha 2016-09-28T17:26:33Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191191#M882355 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Num(Sum({&lt;[Account Description] = {'Total COGS'}, MonthYear = {"$(='&gt;' &amp; Date(AddMonths(QuarterStart(AddMonths(Max(MonthYear), 1))-1,<SPAN style="color: #ff0000;"> -24</SPAN>)) &amp; '&lt;=' &amp; Date(<SPAN style="color: #ff0000;">AddMonths(</SPAN>QuarterStart(AddMonths(Max(MonthYear), 1))-1<SPAN style="color: #ff0000;">, -12</SPAN>))"}, Year, Month, Quarter&gt;} Actual),'#,##0')</STRONG></P></BODY></HTML> Wed, 28 Sep 2016 17:28:04 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191191#M882355 sunny_talwar 2016-09-28T17:28:04Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191192#M882356 <HTML><HEAD></HEAD><BODY><P>2008</P></BODY></HTML> Wed, 28 Sep 2016 17:29:45 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191192#M882356 2016-09-28T17:29:45Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191193#M882357 <HTML><HEAD></HEAD><BODY><P><STRONG>I added an additional</STRONG></P><P><STRONG> ) </STRONG></P><P><STRONG>after the last -12 and it worked like a charm!&nbsp; </STRONG></P><P><STRONG>Thank you - Sunny T!</STRONG></P><P><STRONG>Kelly</STRONG></P></BODY></HTML> Wed, 28 Sep 2016 17:34:44 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191193#M882357 2016-09-28T17:34:44Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191194#M882358 <HTML><HEAD></HEAD><BODY><P>Right, I forgot to add that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 28 Sep 2016 17:44:52 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191194#M882358 sunny_talwar 2016-09-28T17:44:52Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191195#M882359 <HTML><HEAD></HEAD><BODY><P>Wow, you just pushed my past 100,000 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 28 Sep 2016 17:52:18 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191195#M882359 sunny_talwar 2016-09-28T17:52:18Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191196#M882360 <HTML><HEAD></HEAD><BODY><P>YAY Sunny T!&nbsp; Congrats!&nbsp; </P></BODY></HTML> Wed, 28 Sep 2016 18:12:16 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191196#M882360 2016-09-28T18:12:16Z Re: AddYears - how to? https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191197#M882361 <HTML><HEAD></HEAD><BODY><P>Thanks Kelly <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 28 Sep 2016 18:19:36 GMT https://community.qlik.com/t5/QlikView/AddYears-how-to/m-p/1191197#M882361 sunny_talwar 2016-09-28T18:19:36Z