Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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