creating individual qvds automatically for last 12 months per month wise

[Raya]

Hello Experts,

I have Requirement to created the qvd on the month wise, As of the i have one historic qvd where all 12 months data got loaded and getting data loaded on incremental basis. however due to huge volume of data qvd is getting corrupted and creating problem so need to maintain the qvd's on month manner. like below

Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25

let's say today we are in April 2025, all this month is should load april month data and stored inot april month qvd. once April is passed extraction automatically creates may month qvd.

Also can you please assist me how do dynamic app titling based on the date data availability in app . eg: Sales jan_2024 , feb_2024 

[PrashantSangle]

It is possible

1: Create table which hold always last 12 months name

2: Use for loop

   2.1: Use variable to hold month name

   2.1: pass variable in for loop to pull that month data

   2.2: Use store command with same variable to create qvd.

Regards,

Prashant Sangle