Load date after date with loop function

Anonymous — Fri, 13 Apr 2012 17:49:40 GMT

Dear QlikView hobbyists ,

Could anybody please explain to me how to load data date after date. I need to do this because I use the Google Analytics API which doesn't allows me to load more then X records per hour. So, when I am able to create a loop, I can load my data from 01-01-2009 - Today. Between each date I will use the sleep function, so I don't load to much rows per hour.

I uploaded an excel file to make clear what I mean. At first I would like to load the 1e of April, then use the sleep function. After that I would like to run the same script again, but at that time for the 2e of April. I read the help on this, but unfortunately can't perform it. I hope anyone of you can help me out.

Cheers,
Henco

Re: Load date after date with loop function

Fri, 13 Apr 2012 18:02:46 GMT

is this what you need?

Load date after date with loop function

Anonymous — Fri, 13 Apr 2012 18:32:36 GMT

Hi Juan,

Thanks for your reply. Actually I would like to this in the script.

Load the data from the excel file date after date.

Kind regards,

Henco

topic Re: Load date after date with loop function in QlikView

Load date after date with loop function

Re: Load date after date with loop function

Load date after date with loop function