Google Analytics Connector Data query from URI dynamic date

[#1]

Hi,

I have load script which has been pulled from GoogleAnalyticsConnectorV3_DataFromQueryURI:

LOAD

....

....

...

FROM [http://localhost:.......................start-date%3d2012-03-01%26end-date%3d2014-04-04](qvx);

My client is asking me to use today's date in place of end-date%3d2014-04-04. Because every time client doesn't want to go to the google API to get Query URI.

How I can make it dynamically??

Thanks,

[chrisbrain]

We have an example of this in our demo QVSource application:

QVSource/QVSource-Google-Analytics-Starter-App-For-QlikView-V2 · GitHub

Basically you can use something like this:

let vToday = Date(timestamp(now(1)));

let vTodayString = date(vToday, 'YYYY-MM-DD');

LOAD

....

....

...

FROM [http://localhost:.......................start-date%3d2012-03-01%26end-date%3d$(vTodayString)](qvx);

[#3]

Hi,

Did you any one come across the scenario.

Thanks,

[Anonymous]

Hello,

I've found a way, if you want, you can see here:

http://bit.ly/1PQZ0Wj

Best Regards,