topic Data Load Editor trying to return previous 12 months in Connectivity & Data Prep

Data Load Editor trying to return previous 12 months

prosell8 — Wed, 04 Oct 2023 19:35:35 GMT

Hello Qlik Group,

I'm trying to return the last 12 months when loading data from a QVD. I'm able to return previous day but not month. The logic below is what I have but not sure if my syntax is not formatted properly.

vNoOfMonths = 12;
For i = 0 to vNoOfMonths-1
//Let vMonth = Date(AddMonths(Today(),-$(i)),'YYYYMM');// this works for previous day

Let vMonth = Date(AddMonths(Month(),-$(i)),'YYYYMM'); // Returns Error

The following error occurred:

Cannot open file: 'lib://QVD - (Native Path: *** System error: ***)

Trace $(vMonth);

Any help would help,

Cheers

Re: Data Load Editor trying to return previous 12 months

hic — Wed, 04 Oct 2023 19:50:36 GMT

Month() must have a parameter.

You probably want a date representing the month. Try MonthStart(Today()) instead. Hence:

Let vMonth = Date(AddMonths(MonthStart(Today()),-i),'YYYYMM');

Re: Data Load Editor trying to return previous 12 months

prosell8 — Wed, 04 Oct 2023 20:25:48 GMT

Hi,

Thank you for the solution. Unfortunately, it stills brings in October 2023.

Re: Data Load Editor trying to return previous 12 months

prosell8 — Thu, 05 Oct 2023 15:25:08 GMT

Found a solution to my issue.

Let vMonth = Date(AddMonths(AddMonths(today()-1,-1),-$(i)),'YYYYMM');