Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
newuser
Contributor III
Contributor III

Pivot Table Add Column YoY By Month

Hello - I've searched the forums about this question but haven't arrived at a clear answer yet:

Say I have a pivot table that has one dimension as a row, and TWO columns: first by month (Jan, Feb, Mar), then by year. What I’m trying to do is calculate YoY within month. When I add an expression to the pivot table, it is calculating for each year, when I want it to calculate by month. Plus not 100% sure of the proper syntax.

The data has more than two years, so the calculated column has to be “smart” enough to handle whichever two years the user chooses.

Any ideas? Example of what the final pivot table should look like - the first row is just for clarity indicating the month column.

 JanJanJanFebFebFeb
 Year1Year2YoYYear1Year2Yoy
Dimension value1      
Dimension value2      

Thanks for any tips you can provide!

Labels (1)
2 Replies
Channa
Specialist III
Specialist III

there are some based on ROW 

using above function try column 1/column2

there is function Column(1)/Column(2)

may be

Channa
newuser
Contributor III
Contributor III
Author

Tried that and got zeros. So am trying something different - the measure below I've added to return the amount for max year. I have it where month is the only column. The expression "Yr" has the year. The set expression below is not recognizing max year. Instead it is summing across all years. Any ideas?

Sum({$<Yr={$(=max(Yr))}>  }amount)