Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jeckstein
Not applicable

Looping through dates in API call.

I have a load statement like this

Data:

Load

     Dim_1,

     Dim_2,

     Met_1,

     Met_2

From

[

[http://localhost:5526start-date%3d  yesterday  %26end-date%3d  today  %26metrics

(qvx);

I need to make yesterday and today variables and loop them through the following date range.

2015-08-31 through today 2016-12-26.

The variables need to be in these date format YYYY-MM-DD.

so

the 1st pull should be                     yesterday=2015-08-31 today=2015-09-01

the 2nd pull should be                    yesterday=2015-09-01 today=2015-09-02

the 3rd pull should be                     yesterday=2015-09-02 today=2015-09-03

this pattern should continue until      yesterday=2016-12-25 today=2016-12-26

Thanks in advance.