topic Re: for loop in qlikview with dates (BY WEEK) in QlikView

for loop in qlikview with dates (BY WEEK)

Tue, 30 Sep 2014 20:39:19 GMT

http://community.qlik.com/thread/78869-- This for loop worked out great!

BUT I need to tweek it to loop by week, rather than loop each day..

Any suggestions on how I can accomplish that?

let vDays = num#((today()-1) - date#('1/01/2014','MM/DD/YYYY'));
FOR i= 0 to vDays
let vSuffix = Date((today()-1) - vDays + i, 'MM/DD/YYYY');

LOAD data

NEXT i

Thank you in advance!

Liz

Re: for loop in qlikview with dates (BY WEEK)

MarcoWedel — Tue, 30 Sep 2014 23:17:19 GMT

Hi,

one solution could be:

FOR i= 1 to Week(Today())
   LET vSuffix = MakeWeekDate(2014, i);

   //LOAD data;
   LOAD '$(vSuffix)' as Date
   AutoGenerate 1;

NEXT i;

hope this helps

regards

Marco

Re: for loop in qlikview with dates (BY WEEK)

Wed, 29 Oct 2014 13:49:51 GMT

Hello Marco,

do u know how can I do to do not fix weeks only for 2014 but for all years available into my date field?

I mean, I need one row for each month-year available in my database, not only 2013 or 2014.

Thanx!!

Pablo

Re: for loop in qlikview with dates (BY WEEK)

MarcoWedel — Wed, 29 Oct 2014 15:01:31 GMT

Hi,

please open a thread and specify your requirements.

thanks

regards

Marco

Re: for loop in qlikview with dates (BY WEEK)

Wed, 29 Oct 2014 15:03:45 GMT

Hi Marco, thanks!

I just did it here: http://community.qlik.com/message/644577#644577

Pablo