4 Replies Latest reply: Oct 29, 2014 11:03 AM by pablo masotta RSS

    for loop in qlikview with dates (BY WEEK)

    Liz Bauer

      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!