Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

shivatcs
New Contributor II

how to get last 3 months moving avg sales growth, using pivot table.

Foe the fiscal year how to find previous three month average sales growth using pivot table.

2 Replies

Re: how to get last 3 months moving avg sales growth, using pivot table.

Would you be able to share a sample?

Highlighted
camron_allan
New Contributor II

Re: how to get last 3 months moving avg sales growth, using pivot table.

I don't try to accomplish this with set expressions.  I use a data-drive approach.  You should be using a time dimension. 

I've created a script called QlikRTP‌ which can be used to make your life easier.  You can read about it in my post, here.

RTP stands for Relative Time Periods.  This script leverages your existing month dimension to add the following relative time elements to your app:

  • To-Date ranges such as YTD and QTD
  • Relative time periods such as "Previous Year", "Previous Month", or “same period last year”
  • Rolling periods which are used for moving averages. (Ex. "Rolling 3 month average")
  • Year-over-Year and MoM growth metrics

Not only that, these RTPs will work for any anchor month! (not just the current period)

This approach greatly simplifies your measures by only requiring two set modifiers.