Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Load date after date with loop function

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.


2 Replies
Not applicable

is this what you need?

Creator II
Creator II

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,