Sum of measures for last 6 months - Qlik Community

Anonymous · ‎2018-07-13

I have multiple measures like revenue from product 1 , product 2 , product 3 for each month.

I have the details in the pivot table with the structure mentioned in the attachment.

I want to display a column with sum of last 6 month for each measure.

Any suggestions will be of great help.

Anonymous · ‎2018-07-13

It sounds similar to rolling items into quarters, etc. for financials.

I did a quick search for the quarters, etc. in the community, but think that each are helpful (some qlikview, some similar topics).

I think it would be adding two measures: A) 1 being months 1 <= x <= 6, B) being months 7 <= x <= 12)

Community posts that may be helpful:

Consolidating Months into Quarters

Show data for week,month,quarter,year based on date entered by user.

Financial Quarter

Help Calculating Period-over-Period Growth

Anonymous · ‎2018-07-16

Thanks Robert. I will check it out