topic Re: Load data from current and last year in QlikView

Load data from current and last year

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

i have data from year 2014 on the database, however the data is in the format 201401, 201402 and so on.

how could it be done on the script to load data from current and last year without having to do it where date > 201601, i mean, i want it to be automatic so i don´t have to change it on new year.

Thank you

Re: Load data from current and last year

aarkay29 — Tue, 07 Mar 2017 18:14:28 GMT

Create a variable and use it in the where statement

Let vStartDate= Date(YearStart(AddYears(today(),-1)),'YYYYMM');

Where DateField >='$(vStartDate)';

Re: Load data from current and last year

muthukumar77 — Wed, 08 Mar 2017 09:56:01 GMT

Hi,

Can you send sample data?