creating individual qvds automatically for last 12 months per month wise

Raya — Wed, 02 Apr 2025 09:50:51 GMT

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

Re: creating individual qvds automatically for last 12 months per month wise

PrashantSangle — Wed, 02 Apr 2025 10:17:13 GMT

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

topic Re: creating individual qvds automatically for last 12 months per month wise in App Development

creating individual qvds automatically for last 12 months per month wise

Re: creating individual qvds automatically for last 12 months per month wise