Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Rolling N Months Calculation

Hello,

I have a table like this:


JanFebMarAprMay
Amount120232302322382

When I select Apr, the Pivot Table only shows:


Apr
Total = Sum(Amount)322

How could I make Total to be sum of Feb's, Mar's and Apr's amount, i.e. rolling 3 months, and giving out 856, i.e. 232 + 302 + 322?

Please help and advise. Thank you.

3 Replies
er_mohit
Honored Contributor II

Re: Rolling N Months Calculation

See the attached file

Not applicable

Re: Rolling N Months Calculation

Hello,

Thanks for your help. However, is there a way I could hide the previous months? For example, if I select Apr and May, Feb and Mar would be hidden, however, Apr and May could still show the accumulated total. Is that possible? Please help and advise. Thank you.

Re: Rolling N Months Calculation

See this document for some solutions: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Community Browser