Capturing Historical Snapshots of Expired discounts

[Qlikbuddy]

I have 4 different types of discounts for our telecom client like time limited discount (TLD), Contract, Gifting and Device related. for each of this discount have its own expire date. 

as we know for each type of discount, the number of their projected estimations will change over the month due to churn, discount renewal, save etc.

suppose in 202401 subscriptions with TLD expirations are around 5000, then each month some of them would have been expired as the months going on.

now client requirement is they wanted to see what the original was how many expirations were in 2024 jan. 

below picture will give an idea about what exactly we are looking for. kindly through some light on how to achieve this. your response on this is highly appreciated, many thanks

TLD - TLD_Expire_date

Contract - Ctr_Expire_Date

Gifting - Ctr_Expire_Date (Gifting flag =1)

Device - Device_Expire_Date

[-SW-]

Hi @Qlikbuddy ,
There are few ways of doing this but two I can think of is to start storing qvds at month end to have exactly the right snapshot for the month end. However this method will only work going forward.

You can also use the AS-OF method as described by Henric Cronstrom in the following link:
https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

I tend to use an altered form of Henric's script for my own needs.