Script to create a rolling 12 month value.

scott_simmons — Sat, 16 Nov 2024 01:20:41 GMT

I have a table of information that contains Cust#, Year, Month, SalesTotal. The client wants to classify the customers over a rolling period of the prior 12 months. They want to see how the customer ranks using a rolling 12 month of sales.

For example in

Jan 2020 = sum( Dec 2019 to Dec 2018)

Dec 2019 = sum(Nov 2019 to Nov 2018)

Nov 2019 = sum(Oct 2019 to Oct 2018)

How do I create a script that will create the following table

customer

Current month

prior 12 months sales

Re: Script to create a rolling 12 month value.

Vegar — Wed, 05 Feb 2020 20:06:29 GMT

Take a look at the HIC blog post "The As-of-table". It is a quite good approach for enabling R12 calculations.

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

topic Script to create a rolling 12 month value. in QlikView

Script to create a rolling 12 month value.

Re: Script to create a rolling 12 month value.