Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
newuser
Creator II
Creator II

Pivot Table Month and Year Columns - Calculate Variance

Hello - I have a pivot table with one dimension and two columns - month (first level column) and year (second level column). What I'd like to do is calculate the YoY change by month (so for example, YoY change for Jan, YoY change for Feb, etc). So the YoY calculation would have to be subtotal by month. 

I've seen various posts on YoY using set analysis, but I haven't been able to get there yet. Any ideas?

 

Thanks

0 Replies