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

bmac27 — Thu, 14 Sep 2023 15:48:05 GMT

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'

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

rwunderlich — Thu, 14 Sep 2023 18:32:00 GMT

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

topic Getting .QVD by Month for a Range of Dates (Load editor) in App Development

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

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