Qlik Community

Qlik Sense App Development

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

mohankumar92
New Contributor

Sum of measures for last 6 months

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.

2 Replies
rscampbell
New Contributor III

Re: Sum of measures for last 6 months

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

https://community.qlik.com/thread/186573

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

https://community.qlik.com/thread/148970

Financial Quarter

https://community.qlik.com/thread/161813

Help Calculating Period-over-Period Growth

https://community.qlik.com/thread/8290

mohankumar92
New Contributor

Re: Sum of measures for last 6 months

Thanks Robert. I will check it out

Community Browser