topic Re: Google Analytics Connector Data query from URI dynamic date in QlikView

Google Analytics Connector Data query from URI dynamic date

Tue, 22 Apr 2014 06:54:16 GMT

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,

Re: Google Analytics Connector Data query from URI dynamic date

chrisbrain — Wed, 23 Apr 2014 07:21:43 GMT

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);

Re: Google Analytics Connector Data query from URI dynamic date

Wed, 23 Apr 2014 12:20:48 GMT

Hi,

Did you any one come across the scenario.

Thanks,

Re: Google Analytics Connector Data query from URI dynamic date

Anonymous — Wed, 17 Feb 2016 18:45:54 GMT

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,