topic 3 Year YTD Comparison ( +/- , %) in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134863#M509792 <HTML><HEAD></HEAD><BODY><P>I know this subject of year to date calculation is fairly beat to death, but I have not found anything that is really pointing me in the correct direction.&nbsp; </P><P></P><P>I have a pivot table where I need to show Item #, Item Name in the rows section, and also showing years in the row section as well.</P><P></P><P>I have placed my measures in the columns, I made a measure for each month of the year and the 13th column being a YTD total of that rows year.&nbsp; This part is working great!</P><P></P><P>My issue is I need to show an analysis of this in this format in columns 14 - 15 (similar to the attached jpg),&nbsp; I cant seem to find a way to show the rows year YTD -&nbsp; the previous rows YTD at the very least.</P><P></P><P>This is extremely easy to make in excel, but this is something that is going to be used heavily so I can't use excel as the solution to make these analytics. </P><P></P><P>Please let me know if anyone has a solution for this.&nbsp; </P></BODY></HTML> Mon, 17 Sep 2018 19:25:53 GMT Anonymous 2018-09-17T19:25:53Z 3 Year YTD Comparison ( +/- , %) in Pivot Table https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134863#M509792 <HTML><HEAD></HEAD><BODY><P>I know this subject of year to date calculation is fairly beat to death, but I have not found anything that is really pointing me in the correct direction.&nbsp; </P><P></P><P>I have a pivot table where I need to show Item #, Item Name in the rows section, and also showing years in the row section as well.</P><P></P><P>I have placed my measures in the columns, I made a measure for each month of the year and the 13th column being a YTD total of that rows year.&nbsp; This part is working great!</P><P></P><P>My issue is I need to show an analysis of this in this format in columns 14 - 15 (similar to the attached jpg),&nbsp; I cant seem to find a way to show the rows year YTD -&nbsp; the previous rows YTD at the very least.</P><P></P><P>This is extremely easy to make in excel, but this is something that is going to be used heavily so I can't use excel as the solution to make these analytics. </P><P></P><P>Please let me know if anyone has a solution for this.&nbsp; </P></BODY></HTML> Mon, 17 Sep 2018 19:25:53 GMT https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134863#M509792 Anonymous 2018-09-17T19:25:53Z Re: 3 Year YTD Comparison ( +/- , %) in Pivot Table https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134864#M509793 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 29px;">This article could help you.</SPAN></P><P></P><P><A href="https://community.qlik.com/docs/DOC-8242">Missing Manual - Above() and Below()</A></P></BODY></HTML> Mon, 17 Sep 2018 21:22:26 GMT https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134864#M509793 MarioCenteno 2018-09-17T21:22:26Z Re: 3 Year YTD Comparison ( +/- , %) in Pivot Table https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134865#M509794 <HTML><HEAD></HEAD><BODY><P>This is exactly what I was looking for, thank you very much! </P></BODY></HTML> Tue, 18 Sep 2018 13:42:41 GMT https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134865#M509794 Anonymous 2018-09-18T13:42:41Z Re: 3 Year YTD Comparison ( +/- , %) in Pivot Table https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134866#M509795 <HTML><HEAD></HEAD><BODY><P>Your welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Sep 2018 15:53:44 GMT https://community.qlik.com/t5/QlikView/3-Year-YTD-Comparison-in-Pivot-Table/m-p/134866#M509795 MarioCenteno 2018-09-18T15:53:44Z