Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
blockmind1
Partner - Contributor
Partner - Contributor

Calculate YoY by Year in Pivot Table with Year as Measure

Hello. I got this pivot table, as you see I have several dimensions and about 7 measures, filtered by year. 

dudaQlik.PNG

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. 

I have tried aggr, above, year-1, etc, etc, but couldn´t make it work.  It just filters the year from the filter or makes nonsense values. 


I hope someone had the same problem. 

Thank you in advance. 

Labels (6)
0 Replies