topic Calculate YoY by Year in Pivot Table with Year as Measure in App Development https://community.qlik.com/t5/App-Development/Calculate-YoY-by-Year-in-Pivot-Table-with-Year-as-Measure/m-p/1784000#M61108 <P>Hello. I got this pivot table, as you see I have several dimensions and about 7 measures, filtered by year.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dudaQlik.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49405iE5CF608F8336AED1/image-size/large?v=v2&amp;px=999" role="button" title="dudaQlik.PNG" alt="dudaQlik.PNG" /></span></P><P>I just want to get the YoY analysis. The user can filter how many years to compare, then you see the total sales from each year and then I want to see the % of variation from the year before.&nbsp;</P><P>I have tried aggr, above, year-1, etc, etc, but couldn´t make it work.&nbsp; It just filters the year from the filter or makes nonsense values.&nbsp;</P><P><BR />I hope someone had the same problem.&nbsp;<BR /><BR /></P><P>Thank you in advance.&nbsp;</P> Sat, 16 Nov 2024 17:28:19 GMT blockmind1 2024-11-16T17:28:19Z Calculate YoY by Year in Pivot Table with Year as Measure https://community.qlik.com/t5/App-Development/Calculate-YoY-by-Year-in-Pivot-Table-with-Year-as-Measure/m-p/1784000#M61108 <P>Hello. I got this pivot table, as you see I have several dimensions and about 7 measures, filtered by year.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dudaQlik.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49405iE5CF608F8336AED1/image-size/large?v=v2&amp;px=999" role="button" title="dudaQlik.PNG" alt="dudaQlik.PNG" /></span></P><P>I just want to get the YoY analysis. The user can filter how many years to compare, then you see the total sales from each year and then I want to see the % of variation from the year before.&nbsp;</P><P>I have tried aggr, above, year-1, etc, etc, but couldn´t make it work.&nbsp; It just filters the year from the filter or makes nonsense values.&nbsp;</P><P><BR />I hope someone had the same problem.&nbsp;<BR /><BR /></P><P>Thank you in advance.&nbsp;</P> Sat, 16 Nov 2024 17:28:19 GMT https://community.qlik.com/t5/App-Development/Calculate-YoY-by-Year-in-Pivot-Table-with-Year-as-Measure/m-p/1784000#M61108 blockmind1 2024-11-16T17:28:19Z