topic Re: Addition base on Year/Period in QlikView https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983312#M335647 <HTML><HEAD></HEAD><BODY><P>If you have an application with test data to share it will be much easier for us to help you quickly. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 06 Sep 2015 17:42:22 GMT petter 2015-09-06T17:42:22Z Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983306#M335641 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Plz I wanna add <SPAN style="text-decoration: underline;"><STRONG style="color: #000000; text-decoration: underline;">(Full Bal.) 2011</STRONG></SPAN> + <SPAN style="text-decoration: underline;"><STRONG>(Full Bal.) 2012</STRONG></SPAN><STRONG> </STRONG> =&nbsp; <STRONG style="text-decoration: underline;">(Bal. Subtract 2012 - 2013) 2012</STRONG></P><P></P><P>same for the next then <SPAN style="text-decoration: underline;"><STRONG style="color: #000000; text-decoration: underline;">(Full Bal.) 2011</STRONG></SPAN> + 0 = <SPAN style="text-decoration: underline;"><STRONG>(Bal. Subtract 2012 - 2013) 2011</STRONG></SPAN></P><P></P><P></P><P></P><P></P><P></P><P></P><P>How do I resolve this?<SPAN style="text-decoration: underline;"></SPAN></P><P><IMG alt="subtract.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98119_subtract.JPG" style="height: auto;" /></P></BODY></HTML> Sun, 06 Sep 2015 12:59:03 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983306#M335641 2015-09-06T12:59:03Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983307#M335642 <HTML><HEAD></HEAD><BODY><P>It is hard to understand your explanation... sorry</P></BODY></HTML> Sun, 06 Sep 2015 13:04:28 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983307#M335642 petter 2015-09-06T13:04:28Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983308#M335643 <HTML><HEAD></HEAD><BODY><P>Ok,</P><P>please don't mind the name&nbsp; (Bal. Subtract 2012-2013) its just the field name</P><P></P><P><SPAN style="text-decoration: underline;">Full. Ball</SPAN> @ <SPAN style="text-decoration: underline;">2011</SPAN> = <SPAN style="text-decoration: underline;">Bal. Subtract 2012-2013 @ 2011</SPAN></P><P>and</P><P><SPAN style="text-decoration: underline;">Full. Bal</SPAN> @ 2011 - <SPAN style="text-decoration: underline;">Full.Bal</SPAN> @ 2012 = (<SPAN style="text-decoration: underline;">Bal. Subtract 2012-2013)</SPAN> @<SPAN style="text-decoration: underline;"> 2012</SPAN></P><P>and</P><P><SPAN style="text-decoration: underline;">Full. Bal</SPAN> @ 2012 - <SPAN style="text-decoration: underline;">Full.Bal</SPAN> @ 2013 = (<SPAN style="text-decoration: underline;">Bal. Subtract 2012-2013)</SPAN> @<SPAN style="text-decoration: underline;"> 2013</SPAN></P><P>and</P><P><SPAN style="text-decoration: underline;"><SPAN><SPAN>Full. Bal</SPAN></SPAN></SPAN><SPAN></SPAN><SPAN> @ 2013</SPAN><SPAN> -</SPAN><SPAN style="text-decoration: underline;"><SPAN> Full.Bal</SPAN></SPAN><SPAN> @ 2014</SPAN> = (<SPAN style="text-decoration: underline;">Bal. Subtract 2012-2013)</SPAN> @ <SPAN style="text-decoration: underline;">2014</SPAN></P><P><SPAN style="text-decoration: underline;">a</SPAN>nd</P><P><SPAN style="text-decoration: underline;">Full. Bal</SPAN> @ 2014 - Full.Bal @ 2015 = (<SPAN style="text-decoration: underline;">Bal. Subtract 2012-2013) @ 2015</SPAN></P><P></P><P></P><P></P></BODY></HTML> Sun, 06 Sep 2015 13:47:40 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983308#M335643 2015-09-06T13:47:40Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983309#M335644 <HTML><HEAD></HEAD><BODY><P>Yes this what I meant</P><P><IMG alt="subtract.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98144_subtract.JPG" style="height: auto;" /></P></BODY></HTML> Sun, 06 Sep 2015 13:56:49 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983309#M335644 2015-09-06T13:56:49Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983310#M335645 <HTML><HEAD></HEAD><BODY><P>My guess is you want the values of previous year (row): you can use the above function.</P></BODY></HTML> Sun, 06 Sep 2015 15:54:46 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983310#M335645 maxgro 2015-09-06T15:54:46Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983311#M335646 <HTML><HEAD></HEAD><BODY><P>Picking above value in sum calculation give wrong answers. especially&nbsp; on pivot table which am using</P></BODY></HTML> Sun, 06 Sep 2015 17:08:38 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983311#M335646 2015-09-06T17:08:38Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983312#M335647 <HTML><HEAD></HEAD><BODY><P>If you have an application with test data to share it will be much easier for us to help you quickly. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 06 Sep 2015 17:42:22 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983312#M335647 petter 2015-09-06T17:42:22Z Re: Addition base on Year/Period https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983313#M335648 <HTML><HEAD></HEAD><BODY><P>Ok, Find attached.</P><P></P><P>Thanks Petter</P></BODY></HTML> Tue, 08 Sep 2015 13:51:04 GMT https://community.qlik.com/t5/QlikView/Addition-base-on-Year-Period/m-p/983313#M335648 2015-09-08T13:51:04Z