Getting .QVD by Month for a Range of Dates (Load editor)

[bmac27]

I have a script that loads a range of dates based on a variable set.

let vStart = '2/3/2017';
let vEnd = '4/19/2024'

TEMP:
LOAD
ID,
Date,
Status,
Type,
Amount,
Customer,
FROM [lib://DataFiles/data_exam_raw.xlsx]
(ooxml, embedded labels, table is Data)
WHERE (Date >= '$(vStart)' AND Date <= '$(vEnd)') ;

How can I implement a loop to take this data range and load into a qvd by month? I know it would be a 'store data into' with a variable for the name, but how would I loop to retrieve that name within the range.

EX: 'Feb_2017.qvd'

[rwunderlich · Accepted solution]

See the example here of splitting data into QVD by month.

https://qlikviewcookbook.com/2022/03/how-to-segment-qvd-files/

You would load your TEMP table as shown and then process the Resident TEMP table as shown in the blog post. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com