topic Loading selective data based on period in QlikView

Loading selective data based on period

Anonymous — Tue, 17 Jul 2018 03:05:38 GMT

Hi ,

I have source data which is like

MAY-2018,1,2,3,4

APR-2018,1,2,3,4

DEC-2017,1,2,3,4

If current month is JULY-2018 then I want to avoid loading data older than 6+1 month hence in the loading I want to avoid loading DEC-2017 entry.

thanks,

Re: Loading selective data based on period

olivierrobin — Tue, 17 Jul 2018 15:25:49 GMT

hello

try something like

let a=date(today(),'MMM-YYYY');

let b=date(addmonths(a,-6),'MMM-YYYY');

and in you load, add a where clause

DateLoad>=b;

Re: Loading selective data based on period

Anonymous — Fri, 20 Jul 2018 02:26:54 GMT

Hi, Does it not require to convert the first column to the date format? Because I already tried the above method but it is loading 0 rows i.e. nothing.

Re: Loading selective data based on period

Anonymous — Fri, 20 Jul 2018 08:19:20 GMT

I did try something like below in the where clause but it didn't work.

Where Date(MONTH&'-'&YEAR,'MMM-YYYY') >= date(AddMonths(Today(), -7),'MMM-YYYY');

Re: Loading selective data based on period

sergio0592 — Fri, 20 Jul 2018 08:41:02 GMT

Try with :

Where Date(Date#(MONTH&'-'&YEAR,'MMM-YYYY')) >= AddMonths(Today(),-7) ;

Re: Loading selective data based on period

tresB — Fri, 20 Jul 2018 08:51:33 GMT

Where Date#(Date,'MMM-YYYY') >= AddMonths(Today(),-7);

Re: Loading selective data based on period

Anonymous — Fri, 20 Jul 2018 09:30:26 GMT

both solutions are working.