Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

Cheers,
Henco

2 Replies
Not applicable
Author

is this what you need?

Anonymous
Not applicable
Author

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